skip to main content
Non-Supported SQL-92 functionality : Join and Union operations : EXCEPT
 

EXCEPT

EXCEPT is used to return all rows that are in the first table except those that also appear in the second table.
SELECT * FROM music_titles
EXCEPT CORRESPONDING BY (title, artist_more, distributor, record_label)
SELECT * FROM discontinued_albums;