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.
The syntax of the VALUES
clause in RisingWave is as follows:
VALUES
clause to construct a temporary table and assign that table to the view or materialized view. For example:
VALUES
clause can also be used in more complex queries, such as subqueries or joins, to generate temporary tables or insert data into existing tables. For example:
join_mv
: