Post
Ask Question

Find nth Lowest Salary from TYable EmpDetails

Syntax:
  1. Select salary from EmpDetails e  
  2. where (n-1)=  
  3. (select distinct(count(salary))  
  4. from EmpDetails f  
  5. where  
  6. e.salary<f.salary)  
Example: Find the 2nd highest salary from table Employee: 
  1. select salary from EmpDetails e  
  2. where(1)=  
  3. (select distinct(count(salary))  
  4. from EmpDetails f  
  5. where  
  6. e.salary<f.salary)