SQL> select * from aa;ID FID
-- ---
1 0
2 1
3 1
4 2
5 3
6 4
6 5select id from
(select id,level num
from aa
connect by prior id = fid
start with fid = 0
order by num desc)
where rownum<=1
-- ---
1 0
2 1
3 1
4 2
5 3
6 4
6 5select id from
(select id,level num
from aa
connect by prior id = fid
start with fid = 0
order by num desc)
where rownum<=1
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货