Difference between UNION and UNION ALL.

 Posted by Vishalneeraj-24503 on 4/1/2015 | Category: Sql Server Interview questions | Views: 2179 | Points: 40
Select from following answers:
  1. Both are similar
  2. UNION ALL is no longer supported in sql server 2008 onward
  3. UNION returns only unique records from both tables. UNION ALL returns all records from both tables
  4. All of the above.
  5. All Above

Show Correct Answer

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response