> ## 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.

<CardGroup>
  <Card title="Literals" icon="file-lines" iconType="solid" href="/sql/query-syntax/literals"> Introduction of various types of literals. </Card>
  <Card title="Value expressions" icon="laptop-code" iconType="solid" href="/sql/query-syntax/value-exp"> Specify the value returned by a particular column. </Card>
  <Card title="Generated columns" icon="table-columns" iconType="solid" href="/sql/query-syntax/generated-columns"> Create a generated column when creating a table or source. </Card>
  <Card title="FROM clause" icon="location-crosshairs" iconType="solid" href="/sql/query-syntax/from-clause"> Specify the source of the data on which the query should operate. </Card>
  <Card title="WHERE clause" icon="expand" iconType="solid" href="/sql/query-syntax/where-clause"> Specify any conditions or filters to apply to your data. </Card>
  <Card title="GROUP BY clause" icon="layer-group" iconType="solid" href="/sql/query-syntax/group-by-clause"> Group rows in a table with identical data </Card>
  <Card title="HAVING clause" icon="filter" iconType="solid" href="/sql/query-syntax/having-clause"> Eliminate group rows that do not satisfy a given condition. </Card>
  <Card title="ORDER BY clause" icon="sort" iconType="solid" href="/sql/query-syntax/order-by-clause"> Sort the result set of a query in ascending or descending order. </Card>
  <Card title="LIMIT clause" icon="circle-xmark" iconType="solid" href="/sql/query-syntax/limit-clause"> Restrict the number of rows fetched. </Card>
  <Card title="VALUES clause" icon="bars" iconType="solid" href="/sql/query-syntax/values-clause"> Generate one or more rows of data as a table expression </Card>
  <Card title="Set operations" icon="keyboard" iconType="solid" href="/sql/query-syntax/set-operations"> The results of two queries can be combined using the set operations UNION and INTERSECT. </Card>
  <Card title="WITH clause" icon="gear" iconType="solid" href="/sql/query-syntax/with-clause"> Write supplemental statements for a larger query.  </Card>
  <Card title="WITH ORDINALITY clause" icon="gears" iconType="solid" href="/sql/query-syntax/with-ordinality-clause"> Used with set functions in the FROM clause of a query. </Card>
</CardGroup>