how to find 5th min salary from table code example
Example: how to find 5th min salary from table
select min(salary) from
(select distinct salary from employees order by salary desc)
where rownum<=5;
select min(salary) from
(select distinct salary from employees order by salary desc)
where rownum<=5;