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.
Hint : This puzzle is based on my previous article SQL SERVER – Union vs. Union All – Which is better for performance?
Reference : Pinal Dave (http://blog.SQLAuthority.com)