求Oracle最快算法!
表:
___________________________
ID NAME DEPTNAME
1 A A1
2 A A2
3 A A3
4 B B1
5 B B2
6 B B3
7 B B4
8 C C1
9 C C2要求查询结果:
__________________________
ID NAME DEPTNAME
1 A A1,A2,A3
2 B B1, B2, B3, B4
3 C C1,C2求Oracle最快算法!
表:
___________________________
ID NAME DEPTNAME
1 A A1
2 A A2
3 A A3
4 B B1
5 B B2
6 B B3
7 B B4
8 C C1
9 C C2要求查询结果:
__________________________
ID NAME DEPTNAME
1 A A1,A2,A3
2 B B1, B2, B3, B4
3 C C1,C2求Oracle最快算法!
GROUP BY NAME
9可以用sys_connect_by
(select 1+row_number() over(partition by name order by id) rn,row_number() over(partition by name order by id) rn1 ,name,dept from a)
start with rn1=1
connect by rn1=prior rn and name=prior name
group by name