FROM clause
Specify the data source for a query.
Generated columns
Generate columns from other columns in a table or source.
GROUP BY clause
Group rows with similar values.
HAVING clause
Filter results based on specified conditions.
Joins
A JOIN clause, also known as a join, combines the results of two or more table expressions based on certain conditions, such as whether the values of some columns are equal.
LIMIT clause
Restrict the number of rows fetched.
Literals
Enhance data representation accuracy.
ORDER BY clause
Sort the result set of a query.
Set operations
Combine query results.
Value expressions
Represent fixed values in SQL commands.
VALUES clause
Generate one or more rows of data as a table expression.
WHERE clause
Specify any conditions or filters.
WITH clause
Add supplemental statements for a query.
WITH ORDINALITY clause
Add an additional integer column to the table.