find second highest salary employee by using sql

Question

Anonymous · Accepted Answer

SELECT 
    fact.NAME
    fact.SALARY
FROM (
        SELECT 
            emp.NAME
            , emp.SALARY
            , ROW_NUMBER() (OVER ORDER BY emp.SALARY)  rownum
        FROM EMPLOYEES emp
        ) fact
WHERE fact.rownum = 2

Con Edison

Con Edison interview question

Interview Answer

Want the inside scoop on your own company?

Bowls

Followed companies

Job searches