递归
create table table1(t1 varchar(10),t2 int)
insert into table1 values('A',4)
insert into table1 values('B',2)
insert into table1 values('C',2)
insert into table1 values('D',3)
with RelClass
as
(
SELECT *, 1 As n FROM table1
union All
SELECT B.t1,B.t2,B.n+1 as n FROM RelClass B WHERE B.t2>B.n
)
SELECT * from RelClass