EXCEPT returns any distinct values from the dataset to the left of the EXCEPT operator that are not also returned from the right dataset.
Example Databases and Tables
Select dataset except where values are in this other dataset
This modified text is an extract of the original Stack Overflow Documentation created by following contributors
and released under CC BY-SA 3.0