sql - 如何在oracle的emp表中找到前三名最高工资？

Question

如何在emp中找到前三名最高薪水oracle中的表？

Answer 1

SELECT  *FROM 
    (
    SELECT *FROM emp 
    ORDER BY Salary desc
    )
WHERE rownum <= 3
ORDER BY Salary ;