Please see the below example
select * from tablename1
except
select * from tablename2
Note : while using except
All queries combined using a UNION, INTERSECT or EXCEPT operator must have an equal number of expressions in their target lists.
Mark it answer if it is your solution.
Thanks
Ashish