> ## Documentation Index
> Fetch the complete documentation index at: https://docs.risingwave.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Query syntax

> Syntax and usage of common query clauses.

> [card] [Literals](https://docs.risingwave.com/sql/query-syntax/literals.md)
>
> Introduction of various types of literals.

> [card] [Value expressions](https://docs.risingwave.com/sql/query-syntax/value-exp.md)
>
> Specify the value returned by a particular column.

> [card] [Generated columns](https://docs.risingwave.com/sql/query-syntax/generated-columns.md)
>
> Create a generated column when creating a table or source.

> [card] [FROM clause](https://docs.risingwave.com/sql/query-syntax/from-clause.md)
>
> Specify the source of the data on which the query should operate.

> [card] [WHERE clause](https://docs.risingwave.com/sql/query-syntax/where-clause.md)
>
> Specify any conditions or filters to apply to your data.

> [card] [GROUP BY clause](https://docs.risingwave.com/sql/query-syntax/group-by-clause.md)
>
> Group rows in a table with identical data

> [card] [HAVING clause](https://docs.risingwave.com/sql/query-syntax/having-clause.md)
>
> Eliminate group rows that do not satisfy a given condition.

> [card] [ORDER BY clause](https://docs.risingwave.com/sql/query-syntax/order-by-clause.md)
>
> Sort the result set of a query in ascending or descending order.

> [card] [LIMIT clause](https://docs.risingwave.com/sql/query-syntax/limit-clause.md)
>
> Restrict the number of rows fetched.

> [card] [VALUES clause](https://docs.risingwave.com/sql/query-syntax/values-clause.md)
>
> Generate one or more rows of data as a table expression

> [card] [Set operations](https://docs.risingwave.com/sql/query-syntax/set-operations.md)
>
> The results of two queries can be combined using the set operations UNION and INTERSECT.

> [card] [WITH clause](https://docs.risingwave.com/sql/query-syntax/with-clause.md)
>
> Write supplemental statements for a larger query.

> [card] [WITH ORDINALITY clause](https://docs.risingwave.com/sql/query-syntax/with-ordinality-clause.md)
>
> Used with set functions in the FROM clause of a query.


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.