Back to Clickhouse

EXCEPT modifier

docs/en/sql-reference/statements/select/except_modifier.md

26.4.1.1-new515 B
Original Source

EXCEPT modifier {#except}

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

Syntax {#syntax}

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

Examples {#examples}

sql
SELECT * EXCEPT (i) from columns_transformers;
response
┌──j─┬───k─┐
│ 10 │ 324 │
│  8 │  23 │
└────┴─────┘