Powered by Zoomin Software. For more details please contactZoomin

DataDirect OpenAccess SDK Help

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;
TitleResults for “How to create a CRG?”Also Available inAlert