The query to get the employee with the 3rd maximum salary in MySQL.

• Use the ORDER BY clause to sort the salaries in descending order.

• Use the LIMIT clause to retrieve the third row.

• Use a subquery to sel...read more

SELECT * FROM employees ORDER BY salary DESC LIMIT 1 OFFSET 2;