-- [0, 10) の連番を作成
select * from (
WITH SEQ AS ( SELECT 0 as no UNION ALL SELECT no + 1 as no FROM SEQ WHERE no+1 < 1000000 ) select * from SEQ) as SEQ;