7th Highest salary in MYSQL

Question

How to find the row with 7th highest salary from employee table in MySQL? I have tried it this way but unable to get the exact query.

SELECT MAX(salary) FROM employee 
WHERE salary NOT IN 
      (SELECT MAX(salary) FROM employee)

HINT: Use Limit twice with different ordering and a sub query — apomene, Dec 15 '17 at 08:49
i think this link help you please check: https://stackoverflow.com/questions/16234983/how-to-find-third-or-nth-maximum-salary-from-salary-table — DILIP KACHHOT, Dec 15 '17 at 08:55
Just googling your title hits many answsers. Please read & act on [ask]. "Research" — philipxy, Dec 15 '17 at 08:56
I have put the code which i tried, but could not find the exact solution. — Deepak Kumar, Dec 15 '17 at 09:15
@DeepakKumar Hey, try something call `ROW_NUMBER()` to show the line number. Then only u take the 7th row. — Lee, Dec 15 '17 at 09:27
see my code [here](https://stackoverflow.com/a/67261084/1147364) to find nth highest salary — CHANDRA, Apr 26 '21 at 05:08

Blank · Answer 1 · 2017-12-20T08:32:13.473

6

What a brief post!!! Try this though,

select *
from(
    select distinct salary
    from employee
    order by salary desc limit 7
) t
order by salary
limit 1

edited Dec 20 '17 at 08:32

answered Dec 15 '17 at 08:51

Blank

12,308
1
14
32

1

@MKhalidJunaid Fixed it, add `distinct` in subquery. – Blank Dec 20 '17 at 08:33

score 1 · Answer 2 · answered Dec 15 '17 at 08:53

1

maybe you can use this

 SELECT * FROM employe ORDER BY salary DESC LIMIT 7

hope this will help you

answered Dec 15 '17 at 08:53

Hatchwald

300
2
13

1

No, just 7th highest, not all 7. – Deepak Kumar Dec 15 '17 at 08:54
hmm , actually this select all from employe , where order use higest salary use limit 7 higest use DESC – Hatchwald Dec 15 '17 at 08:55

score 0 · Answer 3 · answered Oct 26 '18 at 13:16

0

I got the answer.

SELECT *
   FROM one one1
   WHERE ( 7 ) = ( SELECT COUNT( one2.salary )
                   FROM one one2
                   WHERE one2.salary >= one1.salary
                 )

answered Oct 26 '18 at 13:16

Deepak Kumar

221
3
17

score 0 · Answer 4 · edited Nov 20 '22 at 06:31

0

SELECT *
FROM employees emp
WHERE 7 =
    (SELECT COUNT(DISTINCT salary)
     FROM employees
     WHERE emp.salary<=salary );

edited Nov 20 '22 at 06:31

Ankit Jindal

3,672
3
25
37

answered Nov 19 '22 at 01:07

tushar bhardwaj

1
3

How would this return the 7th highest salary? – Ankit Jindal Nov 20 '22 at 06:30
@AnkitJindal Please find the link https://www.youtube.com/watch?v=4Z61WGRokGQ It will provide the clarification on above query – tushar bhardwaj Nov 22 '22 at 04:59

7th Highest salary in MYSQL

4 Answers4