how we can find nth max salary from an employe table by using my sql?

Categories >> Software >> Databases >> MySQL
Suggest New Category

how we can find nth max salary from an employe table by
using my sql?

Question Posted / samta

8 Answers
13874 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how we can find nth max salary from an employe table by using my sql?..

Answer / pious deepak

select salary from employee
order by salary desc limit n-1, 1

Is This Answer Correct ?

29 Yes

4 No

how we can find nth max salary from an employe table by using my sql?..

Answer / whatinaname

select max(salary) from employee
order by salary desc limit n-1, 1

Is This Answer Correct ?

14 Yes

2 No

how we can find nth max salary from an employe table by using my sql?..

Answer / ksam

select distinct(salary) from employee order by salary desc
limit n-1,1

Is This Answer Correct ?

6 Yes

2 No

how we can find nth max salary from an employe table by using my sql?..

Answer / nivedita

select max(salary) from employee order by salary desc limit 1;

Is This Answer Correct ?

3 Yes

0 No

how we can find nth max salary from an employe table by using my sql?..

Answer / jithu

Another way is::

SELECT sal FROM sal a WHERE n = ( SELECT count(*) FROM sal
b WHERE b.sal < a.sal)

Is This Answer Correct ?

4 Yes

2 No

how we can find nth max salary from an employe table by using my sql?..

Answer / sumit

select salary from employee e1
where (n-1)=(select count(*) from employee where
salary>e1.salary)

Is This Answer Correct ?

0 Yes

2 No

how we can find nth max salary from an employe table by using my sql?..

Answer / sandeep

select MAXIMUM(salary) from (select salary from employee
order by salary desc limit 'n')

n means number of rows

Is This Answer Correct ?

10 Yes

18 No

how we can find nth max salary from an employe table by using my sql?..

Answer / sandeep kumar

select salary from eployee

Is This Answer Correct ?

4 Yes

22 No

Post New Answer