Value expressions
Value expressions are used in a variety of contexts, such as in the target list of the SELECT command, as new column values in INSERT or UPDATE, or in search conditions in a number of commands. The result of a value expression is sometimes called a scalar, to distinguish it from the result of a table expression (which is a table).
Generated columns
A generated column is a special column that is always computed from other columns. In RisingWave, you can create a generated column when creating a table or source.
FROM clause
The FROM clause specifies the source of the data on which the query should operate. Logically, the FROM clause is where the query starts execution. It can contain a single table, a combination of multiple joined tables, or another SELECT query inside a subquery node.
GROUP BY clause
The GROUP BY clause groups rows in a table with identical data, thus eliminating redundancy in the output and aggregates that apply to these groups.
HAVING clause
The HAVING clause is optional and eliminates group rows that do not satisfy a given condition. HAVING is similar to the WHERE clause, but WHERE occurs before the grouping, and HAVING occurs after.
LIMIT clause
LIMIT is an output modifier. Logically it is applied at the end of the query, and the LIMIT clause restricts the number of rows fetched.
VALUES clause
In RisingWave, the VALUES clause is used to generate one or more rows of data as a table expression. It is commonly used in SQL queries to create temporary tables or to insert data into a table.
WHERE clause
The WHERE clause specifies any conditions or filters to apply to your data. This allows you to select only a specific subset of the data. The WHERE clause is used right after the FROM clause.
WITH clause
The WITH clause provides a way to write supplemental statements for a larger query. These statements, also known as Common Table Expressions or CTEs, can be viewed as defining temporary tables that exist just for one query.
JOIN clause
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.