Aprenda SQL, Analytics e
Dashboards na prática

-- Exemplo: segunda maior remuneração por departamento
SELECT department_id, salary
FROM (
  SELECT department_id, salary,
         DENSE_RANK() OVER (PARTITION BY department_id ORDER BY salary DESC) AS rk
  FROM employees
) ranked
WHERE rk = 2;