Write a solution to find the employees who earn the second-highest salary in each department. If multiple employees have the second-highest salary , include all employees with that salary.

Return the result table ordered by emp_id in ascending order.

The result format is in the following example.

Examples

Example 1:

Input:
employees table:
+--------+--------+-----------+
| emp_id | salary

Related Tags