The Main Difference is
UNION returns the data without duplicates
UNION ALL returns the data with duplicates if there any.
UNION is costly as it has to check for redundancy
UNION ALL is faster.
UNION returns the data without duplicates
UNION ALL returns the data with duplicates if there any.
UNION is costly as it has to check for redundancy
UNION ALL is faster.
0 comments:
Post a Comment