SQL Language Guide
:
4. Elements of SQL Statements
:
Common Table Expressions (CTEs)
: Common Table Expression Format
Share this page
Common Table Expression Format
A query that uses a common table expression has the following format:
[ WITH {
with_list_element
},... ]
SELECT_expr
;
where
with_list_element
format is:
table_name
[ ( {
column_name
},... ) ] AS (
query_expr
) ;