RisingWave home page
Current (v2.4)
Search...
⌘K
Ask AI
Blog
Sign up free
Sign up free
Search...
Navigation
Query syntax
Query syntax
Guides
Apache Iceberg™
SQL/UDFs
Python SDK
Client Libraries
RisingWave Console
Changelog
Join Slack community
GitHub
SQL reference
Overview
Commands
Query syntax
Overview
Literals
Value expressions
Generated columns
FROM clause
WHERE clause
GROUP BY clause
HAVING clause
ORDER BY clause
LIMIT clause
VALUES clause
Set operations
WITH clause
WITH ORDINALITY clause
Data types
Functions and operators
Identifiers
System catalogs
Psql commands
User-defined functions
Overview
External UDFs
Embedded UDFs
SQL UDFs
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.
Was this page helpful?
Yes
No
Suggest edits
Raise issue
UPDATE
Literals
Assistant
Responses are generated using AI and may contain mistakes.