表:
Create table tt (id int, name varchar(20),parent_id int)
go
insert tt select 1,'name1', null
union all select 2,'name2',null
union all select 3,'name3',1
union all select 4,'name4',2
union all select 5,'name5',1
union all select 6,'name6',2
union all select 7,'name7',3
union all select 8,'name8',4
go
需要得到这样的分层次的结果:
id name
---------------------------
1/1, name1
2/3, name3
3/7, name7
2/5, name5
1/2, name2
2/4, name4
3/8, name8
2/6, name6
查询语句该怎么写?
|