Bright Tutorials Bright Tutorials
CBSE Class 12 Informatics Practices Question 62 of 91

JOINS and SET Operations — Question 13

Back to all questions
13
Question

Question 13

Are UNION and UNION ALL the same ? Why ?

Answer

No, UNION and UNION ALL are not same. UNION ALL will retain all the duplicate rows from tables in the final output while UNION will remove the duplicate rows from the final output.