sqlite Generate Data using a Recursive Query

Home / Other / sqlite / sqlite Generate Data using a Recursive Query

A query to return 100 records.

WITH RECURSIVE
  rec(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM rec WHERE x<100)
SELECT x, ABS(RANDOM()) % 1000 FROM rec;

A more complex example using two record generators.

WITH RECURSIVE
  ent(e) AS (VALUES(1) UNION ALL SELECT e+1 FROM ent WHERE e<10),
  rec(r) AS (VALUES(1) UNION ALL SELECT r+1 FROM rec WHERE r<100)
SELECT  e, r
FROM    ent
JOIN    rec;

This page was generated by GitHub Pages. Page last modified: 21/03/08 16:49