SQL query to get the 10th highest salary from employee table

• Use ORDER BY and LIMIT clauses

• Subquery can be used to get the 10th highest salary

SELECT salary FROM Employee ORDER BY salary DESC LIMIT N-1, 1

SELECT salary From Employee ORDER BY salary DESC LIMIT 9, 1