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