find second highest salary employee by using sql

Question

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

Pergunta de entrevista da empresa Con Edison

Resposta da entrevista

Empresas seguidas

Buscas de vagas