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

More sql features commands

All sql features commands · DuckDB 2 cheatsheet

Was this page helpful?