SELECT f.course_node_info_id as NODEID, c.course_node_name as NODENAME,c.COURSE_NODE_TYPE as NODELEVEL,c.COURSE_CODE,
case when (select course_node_info_id FROM t_eql_course_frame where f.parent_node_id = COURSE_FRAME_ID) IS NULL then '-1' else (select course_node_info_id FROM t_eql_course_frame where f.parent_node_id = COURSE_FRAME_ID) end as PARENTNODEID
from t_eql_course_frame f,t_eql_course_node_info c
where f.course_node_info_id = c.course_node_info_id and c.DELETE_FLAG = 0
CONNECT BY PRIOR f.course_frame_id = f.PARENT_NODE_ID start WITH f.course_frame_id =(SELECT course_frame_id from T_EQL_COURSE_FRAME where course_node_info_id = 'b7dd0eb6-4d96-4d9e-b56c-5045d249049c' )
order by NODELEVEL, to_number(REPLACE(c.COURSE_CODE,'.',''))
一个复杂的sql
最新推荐文章于 2024-10-13 17:46:39 发布