Select from following answers:- Both are similar
- UNION ALL is no longer supported in sql server 2008 onward
- UNION returns only unique records from both tables. UNION ALL returns all records from both tables
- All of the above.
- All Above
UNION returns only unique records from both tables. UNION ALL returns all records from both tables-> This statement is right about Union and Union All clause.
Show Correct Answer
Asked In: Many Interviews |
Alert Moderator