how to find nth min salary from table
select min(salary) from
(select distinct salary from employees order by salary desc)
where rownum<=n;
4.33
9
select min(salary) from
(select distinct salary from employees order by salary desc)
where rownum<=5;
Thank you!
9
0
Are there any code examples left?
New code examples in category Other