一个复杂的sql

最新推荐文章于 2024-09-20 20:49:53 发布

mystery1004

最新推荐文章于 2024-09-20 20:49:53 发布

阅读量293

点赞数

分类专栏： DB - SQL 文章标签： null sql c

本文链接：https://blog.csdn.net/mystery1004/article/details/4580239

版权

DB - SQL 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

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,'.',''))