记录一下
SELECT *
FROM (SELECT row_number() over(PARTITION BY deptno ORDER BY deptno DESC) lev,
COUNT(0) over(PARTITION BY deptno) cnt,
emp.*
FROM emp)
WHERE lev = 1
ORDER BY deptno DESC
记录一下
SELECT *
FROM (SELECT row_number() over(PARTITION BY deptno ORDER BY deptno DESC) lev,
COUNT(0) over(PARTITION BY deptno) cnt,
emp.*
FROM emp)
WHERE lev = 1
ORDER BY deptno DESC