Write a MySQL query to retrieve the employee with the third-highest salary.

To find the 3rd highest salary, we can use SQL queries with ranking functions or subqueries.

• Use the SQL query: SELECT DISTINCT salary FROM employees ORDER BY salary DESC LIMIT 1 OFFSET 2;

• Alternatively...read more

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

SELECT T1.SALARY

FROM TEST T1

WHERE ( 3 ) = (SELECT COUNT(T2.SALARY)

FROM TEST T2

WHERE T2.SALARY >= T1.SALARY)