17,377
社区成员
发帖
与我相关
我的任务
分享
SELECT DECODE (rn1, 1, deptno, NULL) deptno,
DECODE (rn2, 1, deptname, NULL) deptname, NAME
FROM (SELECT a.*,
ROW_NUMBER () OVER (PARTITION BY deptno ORDER BY deptname,
NAME) rn1,
ROW_NUMBER () OVER (PARTITION BY deptno, deptname ORDER BY NAME)
rn2
FROM a
ORDER BY a.deptno, deptname, NAME)
SELECT DECODE (ROW_NUMBER () OVER (PARTITION BY deptno ORDER BY deptname,
NAME),
1, deptno,
NULL
) deptno,
DECODE
(ROW_NUMBER () OVER (PARTITION BY deptno, deptname ORDER BY NAME),
1, deptname,
NULL
) deptname,
NAME
FROM a