Answers for "how to find nth min salary from table"

0

how to find nth min salary from table

select min(salary) from 
(select distinct salary from employees order by salary desc) 
where rownum<=n;
Posted by: Guest on January-14-2021
0

how to find 5th min salary from table

select min(salary) from 
(select distinct salary from employees order by salary desc) 
where rownum<=5;
Posted by: Guest on January-14-2021

Code answers related to "how to find nth min salary from table"

Browse Popular Code Answers by Language