Use a subquery to find the 5th highest salary in the Employee table.

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

• Use the ROWNUM keyword to limit the results to the 5th highest sala...read more

 Select Salary from employee order by Salary  DESC limit 4,1;