MySQL query to select the id of second highest salary from employee table

• Use ORDER BY clause to sort salaries in descending order

• Use LIMIT to select the second row

• Use a subquery to avoid duplicates if...read more