Join the SingleStore Community Today
Get expert advice, develop skills, and connect with others.
Specifies a temporary named result set, referred to as a Common Table Expression (CTE).
WITH cte [, ...] cte: expression_name[(column_name, ...)] AS select_statement
WITHclauses are supported as part of
WITHclause is not referenced in the
SELECTstatement, it has no effect on the execution of the query.
memsql> WITH myCTE AS (select col from myTable) select col from myCTE; memsql> WITH myCTE (colAlias) AS (select col from myTable) select colAlias from myCTE; memsql> WITH orderCTE AS (select o_orderkey from orders), lineitemCTE AS (select l_orderkey from lineitem) select count(*) from orderCTE join lineitemCTE on o_orderkey = l_orderkey;