Union: It will skip the identical values between  tables. UNION ALL: It will not skip identical values between table instad display all...

UNION and UNION ALL Difference in SQL Server

6:04 AM Raghunatha 0 Comments


Union: It will skip the identical values between  tables.
UNION ALL: It will not skip identical values between table instad display all values of all tables.

here is the sample:















Union Results:
Union ALL results: 
 

0 comments:

Subscribe to: Post Comments (Atom)
Powered by Blogger.