Return the second highest salary in each department. If a department has fewer than two distinct salaries, return null for that department. Ties on salary count once.

Input schema

Example

Constraints

• Output one row per department present in employees, ordered by department_id
• Duplicate salaries in a department are one distinct value
• Up to 2,000,000 rows