sql cte example
WITH expression_name[(column_name [,...])] AS (CTE_definition) SQL_statement; Code language: SQL (Structured Query Language) (sql)
Source: www.sqlservertutorial.net
cte in sql server
CTE: Common Table Expressions 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;
Source: dbfiddle.uk