DuckDB 2 · SQL features
Select all columns except some
Leave out columns without listing the rest.
SELECT * EXCLUDE (internal_id) FROM sales;
Official DuckDB 2 documentation
DuckDB 2 · SQL features
Leave out columns without listing the rest.
SELECT * EXCLUDE (internal_id) FROM sales;
Official DuckDB 2 documentation
Was this page helpful?