34,576
社区成员
发帖
与我相关
我的任务
分享
with m as(
select /* NODECODE ,PARENTNODECODE, NODELEVEL ,NODENAME ,CHILDFLAG,
NODEKEY, RUNSCRIPT, NODEDESCRIPTION ,NODESIGN, NODEORDER */ *, row_number()
over(partition by PARENTNODECODE order by NODECODE) rn FROM ldmenu)
select * from m
where m.rn = 1