SQL

write sql query to find the second highest salary of employee

SELECT MAX(Salary) From Employee
 WHERE Salary < ( SELECT Max(Salary) FROM Employee);

Write an SQL query to determine the 5th highest salary without using TOP or limit method.

select min(salary) from (select distinct salary from worker order by salary  desc) where rownum<=5;