Find nth Lowest Salary from TYable EmpDetails

Sandeep Kumar

11y1.2kCode

In this code Snippet I am writing Query for find nth lowest salary from table.

Syntax:

Select salary from EmpDetails e
where (n-1)=
(select distinct(count(salary))
from EmpDetails f
where
e.salary<f.salary)

Example: Find the 2nd highest salary from table Employee:

select salary from EmpDetails e
where(1)=
(select distinct(count(salary))
from EmpDetails f
where
e.salary<f.salary)