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

分类: 技术问答 • 2022-05-07 14:51:01

问题描述：

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

How to find top three highest salary in emp table in oracle?

答

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