Query syntax
Query syntax
Query syntax
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.