6 ms·
WITH RECURSIVE num AS ( SELECT 1 AS id UNION ALL SELECT id + 1 FROM num ) SELECT * FROM num LIMIT 5; SQL:1999 IIRC.
by 5e92cb50239222b 5y ago
WITH RECURSIVE num AS (
SELECT 1 AS id
UNION ALL
SELECT id + 1 FROM num
)
SELECT * FROM num LIMIT 5;
SQL:1999 IIRC.
- lodi 5y agoAdmittedly though, recursive CTE's like that are a bit of a minefield in practice. It's easy to confuse the query optimizer after chaining a few of those together, or to outright hit a recursion limit (32,767 in SQL Server).