Skip to main content
Journey Uncommon Logo
JourneyUncommon
mediumSQLUNION vs UNION ALLSingle-choice MCQ

For deduplication, how does `UNION` treat two rows that are entirely NULL across all selected columns?

SELECT NULL::int, NULL::text UNION SELECT NULL::int, NULL::text;