4. Understanding the 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 ) ;