/*
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;