#使用递归CTE生成斐波那契数列:0,1,1,2,3,5,8,...

#1.限定最大值

with recursive cte(m, n) as (

select 0, 1

union all

select n, m+n from cte where n<100

) select m from cte;

#2.限定位数

with recursive cte(id, m, n) as (

select 0, 0, 1

union all

select id+1, n, m+n from cte where id<10

) select m from cte;

cte就相当于子查询和视图以及临时表的作用，但是不用维护（视图和临时表需要维护），sql执行完成自动消失