SQL - Structured Query Language |
Except OperatorExcept operator is returns any distinct values from the left query that are not also found on the right query. The number and the order of the columns must be the same in all UNION queries and then data types must be compatible. UNION operator does not ignore duplicate records. The following EXCEPT query is used to combine Sales Year 01 and 02 records. -- Example 41 --
SELECT * FROM Sales_Year_01 EXCEPT SELECT * FROM Sales_Year_02 Query Output Screen |
* * * * *