sql formula to find second minimum value code example
Example: how to find nth min salary from table
select min(salary) from
(select distinct salary from employees order by salary desc)
where rownum<=n;
select min(salary) from
(select distinct salary from employees order by salary desc)
where rownum<=n;