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
最新推荐文章于 2024-01-09 16:13:55 发布
with T as ( select a from (select 1 a) TT union all select a+1 from T where T.a<100 )select * from T