With SqlServer

发布时间：2020-12-12 14:15:49 所属栏目：MsSql教程来源：网络整理

导读：递归 ? 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

递归

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

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!