UNION_VS_UNION_ALL.sql

--UNION SELECT 'A' AS FIRST_RECORD FROM DUAL UNION SELECT 'A' SECOND_RECORD FROM DUAL UNION SELECT 'B' THIRD_RECORD FROM DUAL; --UNION ALL SELECT 'A' AS FIRST_RECORD FROM DUAL UNION ALL SELECT 'A' SECOND_RECORD FROM DUAL UNION ALL SELECT 'B' THIRD_RECORD FROM DUAL ALL;
UNION VS UNION ALL

Be the first to comment

You can use [html][/html], [css][/css], [php][/php] and more to embed the code. Urls are automatically hyperlinked. Line breaks and paragraphs are automatically generated.