SQL SERVER – Simple Puzzle Using Union and Union All | Journey to SQL Authority with Pinal Dave

I often get request to write puzzles using SQL Server. Today, I am presenting one very simple but very interesting puzzle. What will be the output of following two SQL Scripts. First try to answer without running this two script in Query Editor. Script 1 SELECT 1 UNION ALL (SELECT 1 UNION SELECT 2) GO… Continue Reading...

Source: SQL SERVER – Simple Puzzle Using Union and Union All | Journey to SQL Authority with Pinal Dave