EXCEPT
- Last Updated: May 12, 2026
- 1 minute read
- OpenAccess SDK
- Version 8.1
- Documentation
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;