SQLEXCEPT

Download SQL for free

Remarks

EXCEPT returns any distinct values from the dataset to the left of the EXCEPT operator that are not also returned from the right dataset.

Related Examples

Select dataset except where values are in this other dataset