Set Operators (Transact-SQL)

 

THIS TOPIC APPLIES TO: yesSQL Server (starting with 2008)yesAzure SQL DatabaseyesAzure SQL Data Warehouse yesParallel Data Warehouse

SQL Server provides the following set operators. Set operators combine results from two or more queries into a single result set.

EXCEPT and INTERSECT

UNION

Community Additions

ADD
Show: