Statements and clauses

Statements and clauses that aren’t functions: unloading results to object storage, grouping at several levels, and excluding columns or rows.

Statement or clause	Type	What it does
`COPY INTO`	Statement	Unload a query’s results to a CSV file in cloud object storage.
`EXCEPT`	SELECT clause · Set operator	Leave columns out of SELECT *, or remove the rows of one query from another.
`GROUPING SETS, ROLLUP and CUBE`	GROUP BY clause	Compute several levels of aggregation, such as subtotals and grand totals, in one GROUP BY.

Last modified on October 16, 2026