Difference between UNION and UNION ALL.

A. Both are similar
B. UNION ALL is no longer supported in sql server 2000 onward
C. UNION returns only unique records from both tables. UNION ALL returns all records from both tables
Ans: C

0 comments:

Post a Comment

Blogger news