What is the query to find nth highest salary from employee table?

Answer 1

i think aggregation function is tobe used...

select max(salary)..

Answer 2

simple use select max(salary) from faculty;

Answer 3

there is logic required for find second or third maximum salary from table

Answer 4

This will work but there might be something simpler :

Select * from (select * from EMPLOYEES order by Salary desc limit 5) order by Salary limit 1

Answer 5

I would use something like this:

select salary
from employee
where salary > 0
order by salary desc;

This should give you a list of salaries, largest to smallest.

Answer 6

select * from employee order by salary desc limit nth , 1

Answer 7

in ques. we hav to find a specific salary...not a list

Answer 8

select salary from employ where salary =max

Answer 9

selva raj has written the correct answer

Answer 10

select * employee
order by salary DESC