oracle语句

这个语句怎么写？有一个员工表，有4列 ：ID，名字，工资，部门！怎样用语句得到每个部门最高工资的前三个人！用oracle语句怎么写

字段多，麻烦

ID是部门，score是工资，就两字段，其他字段没用

方案一
select id, score
from demoScore e1
where
(
select count(id)
from demoScore e2
where e2.id=e1.id and e2.score>=e1.score
) <=3
order by id, score desc;

方案二
select * from
(select id ,score, row_number() over (partition by id order by score desc) rn
from demoScore)
where rn<=3;

select *from (select row_number over (order by 工资 desc partition by 部门) as row_num ,名字 from table_name)where row_num <= 3

应该加个group by 部门 吧

select *,表.rownum from 表 where rownum>4 order by 工资 desc