with x(编号)
as(select 1 from Test7
union all
select 编号 +1
from x
where 编号+1<=10
)
select * from x
输出1-10
with x(编号)
as(select 1 from Test7
union all
select 编号 +1
from x
where 编号+1<=10
)
select * from x
输出1-10