find second highest salary employee by using sql

Question

Anonimo · 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

Domanda di colloquio di Con Edison

Risposta di colloquio

Aziende seguite

Ricerche di lavoro