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