Skip to main content

Documentation Index

Fetch the complete documentation index at: https://private-7c7dfe99-page-updates.mintlify.app/llms.txt

Use this file to discover all available pages before exploring further.

EXCEPT modifier

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 │
└────┴─────┘