http://www.iteye.com/topic/625574
select d.* from menu d
start with d.PARENTID='0'
connect by prior d.id=d.PARENTID
order siblings by d.ORDERBY asc
menu:表名
PARENTID：父id
'0':根节点id
ORDERBY：排序字段
select d.* from menu d
start with d.PARENTID='0'
connect by prior d.id=d.PARENTID
order siblings by d.ORDERBY asc
menu:表名
PARENTID：父id
'0':根节点id
ORDERBY：排序字段
扫一扫
819
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
