Difference between UNION and UNION ALL in SQL Server
UNION:
UNION performs a DISTINCT on the result set, eliminating any duplicate rows.
UNION ALL:
UNION ALL does not remove duplicates and keeps all the records from tables.
Difference between UNION and UNION ALL
UNION keeps unique records while UNION all does not and therefore UNION ALL is faster than UNION.
#sqlservertutorial #sqlserver #microsoftsqlserver #sqlservertutorialforbeginners #sqltraining
THANK YOU FOR WATCHING!
