Post
Ask Question

Find nth Highest Salary from Table Employee

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