Another option Submitted by Ondrej Kelle (not verified) on Thu, 22/09/2016 - 16:07 Recursive CTE: with x (n) as (select 0 union all select (x.n + 1) n from x where x.n < 99) select * from x; reply
Recursive CTE: