with W as ( select 1, 2 ) select * from W;
create table tq84_1000_records ( id integer primary key ); with num_generator(n) as ( select 1 n union all select 1+n from num_generator limit 1000 ) insert into tq84_1000_records select n from num_generator; select count(*) from tq84_1000_records; -- -- 1000 drop table tq84_1000_records;