EXCEPT modifier

Documentation describing the EXCEPT modifier which specifies the names of one or more columns to exclude from the result. All matching column names are omitted from the output.

Specifies the names of one or more columns to exclude from the result. All matching column names are omitted from the output.

Syntax

SELECT <expr> EXCEPT ( col_name1 [, col_name2, col_name3, ...] ) FROM [db.]table_name

Examples

Query

SELECT * EXCEPT (i) from columns_transformers;

Response

┌──j─┬───k─┐
│ 10 │ 324 │
│  8 │  23 │
└────┴─────┘