Difference between Union and Union all?
Share
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Please briefly explain why you feel this question should be reported.
Please briefly explain why you feel this answer should be reported.
Please briefly explain why you feel this user should be reported.
Please Disable the AdBlocker to Continue to the site.
UNION and UNION ALL
UNION: UNION does not keep duplicate record which means all the records are unique.
UNION ALL: UNION ALL keeps all the records including duplicates.
UNION ALL is faster than UNION because it just concatenates the record.