sql语句问题

Question

表：

我要查询每个部门工资前3名的

Answer 1

table换成你的表名

select * from table  d1 where (select count(*) from table d2 where d2.bumen=d1.bumen and d2.salary>d1.salary) < 3 order by d1.salary  desc

Answer 2

top 3, ordery by salary DESC