June 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home
  • Consulting
  • Training
  • Free Videos
  • All Articles
    • Interview Questions and Answers
    • SQL Tips and Tricks
    • SQL Performance
    • SQL Puzzle
    • Big Data
    • Blog Stats
    • SQL Books
    • Search SQLAuthority
  • Downloads
  • Hire Me
  • Health Check

SQL SERVER – Simple Puzzle with UNION – Part 5

September 11, 2013
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Scripts, SQL Union clause, Union
It seems that my yesterday’s Simple Puzzle with UNION intrigued many readers. Here is my fifth and final part of this Puzzles with UNION. I strongly suggest to read yesterday’s puzzle before continuing today’s puzzle as it is very much based on yesterday’s puzzle. SQL SERVER – Simple Puzzle with UNION…
Read More

SQL SERVER – Simple Puzzle with UNION – Part 4

September 10, 2013
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Union clause, Union
When I started to write Simple Puzzle with UNION last week, I had no clue this will be extremely popular blog post and will turn into a mini-series. Earlier I wrote three different blog posts on this subject and they are very well received. All the three blog posts which…
Read More

SQL SERVER – Simple Puzzle with UNION – Part 3

September 9, 2013
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Union clause, Union
Earlier last week I had two simple puzzles related to UNION clause and the response to those puzzles have been amazing. Lots of email I have received that people wants me to post such basics puzzle again. Well here is one more puzzle which uses UNION and tests your basic…
Read More

SQL SERVER – Simple Puzzle with UNION – Part 2

September 6, 2013
Pinal Dave
SQL, SQL Puzzle, SQL Server, SQL Tips and Tricks
SQL Union clause, Union
Yesterday we had very easy kind of Back to Basics Puzzle with UNION and I have received tremendous response to the simple puzzle. Even though there is no giveaway due to sheer interest in the subject, I have received many replies. Due to all the request, here is another back…
Read More

SQL SERVER – Simple Puzzle with UNION

September 5, 2013
Pinal Dave
SQL, SQL Puzzle, SQL Server, SQL Tips and Tricks
SQL Scripts, SQL Union clause, Union
It has been a long time since played a simple game on SQLAuthority.com. Let us play a simple game today. It is very simple puzzle but indeed a fun one. First let us execute following SQL. Query 1: SELECT 1 UNION ALL SELECT 1 ORDER BY 1 It will return…
Read More

SQL SERVER – UNION ALL and UNION are Different Operation

April 26, 2013
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Union clause, Union

I have previously written about the difference between UNION ALL and UNION multiple times over this blog but it seems like this question never gets old and I keep on getting the question again and again. Let us learn about the different operations about the unions. 

Read More

SQL SERVER – UNION Not Allowed but OR Allowed in Index View – Limitation of the View 6

September 22, 2010
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Index, SQL Scripts, SQL Union clause, SQL View
Update: Please read the summary post of all the 11 Limitations of the view SQL SERVER – The Limitations of the Views – Eleven and more… If you want to create an Indexed View, you ought to know that UNION Operation is not allowed in Indexed View. It is quite surprising…
Read More
Previous 1 2 3 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

© 2006 – 2025 All rights reserved. pinal @ SQLAuthority.com

Go to mobile version