SQL Pattern: Second Highest Salary

WITH ranked AS (
    SELECT
        employee_id,
        salary,

        DENSE_RANK() OVER (
            ORDER BY salary DESC
        ) AS rnk

    FROM employees
)

SELECT *
FROM ranked
WHERE rnk = 2;