With

递归生成 1 到 10 的数字。

WITH RECURSIVE t(n) AS (
    VALUES (1)
    UNION ALL
    SELECT n + 1 FROM t WHERE n < 10
)
SELECT n FROM t;

n
1
2
3
4
5
6
7
8
9
10

递归计算阶乘。

WITH RECURSIVE t(n, [结果]) AS (
    VALUES (0, 1)
    UNION ALL
    SELECT n + 1, [结果] * (n + 1) FROM t WHERE n < 10
)
SELECT * FROM t;

n	结果
0	1
1	1
2	2
3	6
4	24
5	120
6	720
7	5040
8	40320
9	362880
10	3628800