Q. Are UNION and UNION ALL the same? Why?
Answer: -
No, 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.
Answer: -
No, 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.
Post a Comment
You can help us by Clicking on ads. ^_^
Please do not send spam comment : )