WITH recursive t (v) AS (
SELECT 1 -- Исходное значение
UNION ALL
SELECT v + 1 -- Рекурсия
FROM t
)
SELECT v
FROM t
LIMIT 5
#tips
SQ SQL Pro @sqlprofi · 4.91K subscribers WITH recursive t (v) AS (
SELECT 1 -- Исходное значение
UNION ALL
SELECT v + 1 -- Рекурсия
FROM t
)
SELECT v
FROM t
LIMIT 5
#tips