The SQL EXCEPT operator is used to exclude like rows that are found in one query but not another. It returns rows that are unique to one result. To use the EXCEPT operator cps test , both queries must return the same number of columns and those columns must be of compatible data types.