Query syntax

Syntax and usage of common query clauses.

Literals

Introduction of various types of literals.

Value expressions

Specify the value returned by a particular column.

Generated columns

Create a generated column when creating a table or source.

FROM clause

Specify the source of the data on which the query should operate.

WHERE clause

Specify any conditions or filters to apply to your data.

GROUP BY clause

Group rows in a table with identical data

HAVING clause

Eliminate group rows that do not satisfy a given condition.

ORDER BY clause

Sort the result set of a query in ascending or descending order.

LIMIT clause

Restrict the number of rows fetched.

VALUES clause

Generate one or more rows of data as a table expression

Set operations

The results of two queries can be combined using the set operations UNION and INTERSECT.

WITH clause

Write supplemental statements for a larger query.

WITH ORDINALITY clause

Used with set functions in the FROM clause of a query.