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;