EXCEPT - e6data Docs

SELECT clause · Set operator

EXCEPT has two uses in Query Engine: excluding columns from SELECT *, and subtracting one query’s rows from another’s.

SELECT * EXCEPT

Returns every column except the ones you list. Useful for wide tables where you want all but a few columns.

SELECT * EXCEPT (<column> [, ...]) FROM ...

WITH cte AS (SELECT 5 AS c1, 'e6data' AS c2, 10 AS c3)
SELECT * EXCEPT (c3, c2) FROM cte;

c1
5

EXCEPT set operator

Returns the rows of the first query that aren’t in the second, with duplicates removed.

SELECT ...
EXCEPT
SELECT ...

WITH cte AS (
  SELECT 1 AS id, 'AAAA' AS name
  UNION ALL SELECT 2, 'AAAB'
  UNION ALL SELECT 3, 'AAAC'
  UNION ALL SELECT 4, 'AAAD'
)
SELECT * FROM cte
EXCEPT
SELECT * FROM cte WHERE id < 3
ORDER BY 1, 2;

id	name
3	AAAC
4	AAAD

Last modified on November 3, 2026