Set operators in SQL Server 2016 are used to compare rows between input sets. Explore the UNION, INTERSECT, and EXCEPT set operators, the APPLY operator, and the basic components of common table expressions.
Learning Objectives
{"distinguish when to use the UNION and UNION All operators in SQL Server 2016"}