WITH base_10 AS ( SELECT true UNION ALL SELECT true UNION ALL SELECT true UNION ALL SELECT true UNION ALL SELECT true UNION ALL SELECT true UNION ALL SELECT true UNION ALL SELECT true UNION ALL SELECT true UNION ALL SELECT true ), base_100 AS ( SELECT true FROM base_10 b1 CROSS JOIN base_10 b2 ), base_10k AS ( SELECT true constant FROM base_100 b1 CROSS JOIN base_100 b2 ), base_100k AS ( SELECT ROW_NUMBER() OVER (ORDER BY b1.constant) row_num FROM base_10k b1 CROSS JOIN base_10 b2 ) SELECT * FROM base_100k;