How to use Union, Except and Intersect - T-SQL Step by Step Course - Lesson 31 | SQL courses

Duration: 12:49 min

Summary: Union combines the results of two or more queries into a single result set that includes all the rows that belong to all queries in the union. Except returns any distinct values from the left query that are not also found on the right query. Intersect, on the other hand, returns any distinct values that are returned by both the query on the left and right sides of the intersect operand. But you need to keep in mind the following: (1) The number and the order of the columns must be the same in all queries. (2) The data types must be compatible.