SQL

sql cte example

WITH expression_name[(column_name [,...])]
AS
    (CTE_definition)
SQL_statement;
Code language: SQL (Structured Query Language) (sql)

cte in sql server

/*
CTE: Common Table Expressions 
It is a temporary named result set that you can reference within 
a SELECT, INSERT, UPDATE, or DELETE statement.
*/
WITH    
odd_num_cte (id, n) AS    
(    
SELECT 1, 1     
UNION ALL    
SELECT id+1, n+2 from odd_num_cte where id < 5     
)    
SELECT * FROM odd_num_cte;