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

Two branches of a UNION ALL have columns of different but compatible types (INT and NUMERIC). What is the data type of the resulting column?

SELECT 1 AS v -- integer UNION ALL SELECT 2.5 AS v; -- numeric