Query Syntax

[ WITH ... ]
SELECT
   [TOP] ... [EXCLUDE]
[ FROM ...
   [ JOIN ... ]
   [ VALUES ... ] 
]
[ WHERE ... ]
[ GROUP BY ...
   [ HAVING ... ] ]
[ ORDER BY ... [ NULLS FIRST | NULLS LAST ]]
[ LIMIT ...[OFFSET] ]

EXCEPT (column_name)

SELECT * EXCEPT columns that should be excluded from the results

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

c2
5

Last updated