with T as ( select a from (select 1 a) TT union all select a+1 from T where T.a<100 )select * from T
sql 递归查询结果集1 ~ 100
最新推荐文章于 2023-06-12 15:16:32 发布
with T as ( select a from (select 1 a) TT union all select a+1 from T where T.a<100 )select * from T