分区排序问题 一个比较头疼的sql语句! select * from (SELECT depname, empno, salary, rank() OVER (PARTITION BY depname ORDER BY salary DESC) rn FROM empsalary ) where rn<=10;