给定表包含 employee_id, Salary,
City 编写一个查询,以获得每个城市的第五高年薪员工。我的代码: select * from (select * from(select * from (select * from dummy order by sal desc) where rownum<= 5) order by sal) where rownum <=1 ; 但这只给出了总表中第五高的位置。
salary float id integer, ); 我想收集那些根据每个部门的平均年薪排名在第三到第五位之间的员工经过一番搜索,我找不到一个适合我的解决方案。id_employeeAS T on Employee.id = id_employee
ORDER BY Employee.id_department, avg_salary; 这会让我得到正确的员工