SQL> update emp2 2 set sal=sal+200 3 where empno in 4 (select empno 5 from ( select * 6 from (select emp.*,row_number() over(partition by deptno order by sal desc) as rank 7 from emp )a )t 8 where rank=1);
SQL> update emp2 2 set sal=sal+200 3 where empno in 4 (select empno 5 from ( select * 6 from (select emp.*,row_number() over(partition by deptno order by sal desc) as rank 7 from emp )a )t 8 where rank between 1 and 3);--前三名
