Oracle CONNECT BY 层内排序

rm 多级树形结构 使用 Oracle Connect by 进行排序，增加 层内排序

connect by 使用

SELECT t.id,t.curname,t.parent_id,t.order_value FROM TB_COMPANY t WHERE STATUS=1 AND t.id IN
(SELECT DISTINCT r2.company_id FROM r_company_group r2 WHERE r2.group_id IN
(SELECT r.group_id FROM r_company_group r WHERE r.company_id =
(SELECT u.company_id FROM sys_user u WHERE u.login_name = 'kzw')))
CONNECT BY t.PARENT_ID = PRIOR ID START WITH t.PARENT_ID = 0

CONNECT BY使用 ORDER SIBLINGS BY order_value ASC; 根据order_value升序

SELECT t.id,t.curname,t.parent_id,t.order_value FROM TB_COMPANY t WHERE STATUS=1 AND t.id IN
(SELECT DISTINCT r2.company_id FROM r_company_group r2 WHERE r2.group_id IN
(SELECT r.group_id FROM r_company_group r WHERE r.company_id =
(SELECT u.company_id FROM sys_user u WHERE u.login_name = 'kzw')))
CONNECT BY t.PARENT_ID = PRIOR ID START WITH t.PARENT_ID = 0 ORDER SIBLINGS BY order_value ASC;