mirror of
https://github.com/sigmasternchen/fibonacci
synced 2025-03-17 00:58:57 +00:00
14 lines
169 B
SQL
14 lines
169 B
SQL
WITH RECURSIVE fibonacci(i, n1, n2) AS (
|
|
SELECT
|
|
0,
|
|
1,
|
|
1
|
|
UNION ALL
|
|
SELECT
|
|
i + 1,
|
|
n2,
|
|
n1 + n2
|
|
FROM fibonacci
|
|
WHERE i < 8
|
|
)
|
|
SELECT n1 AS n FROM fibonacci
|