MySQL LIMIT inside a subquery

Asked Nov 02 '21 at 14:55

Active Nov 02 '21 at 14:55

Viewed 32 times

From an Employee table, I'm trying to get the second highest salary only. The Employee table has a PK id and a salary column.

Select salary as SecondHighestSalary 
From Employee
where id not in (
    Select id from Employee
    Order By salary desc
    limit 1
)
Order By salary desc 
limit 1

It's returning: This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'

asked Nov 02 '21 at 14:55

myTest532 myTest532

2,091
3
35
78

you can find max() and say max() not in (max() id ) to get 2nd highest – Ali Fidanli Nov 02 '21 at 14:58
Do you have an example of it? – myTest532 myTest532 Nov 02 '21 at 15:16
@myTest532myTest532 should be something like `select salary as SecondHighestSalary From Employee where id not in ( Select max(id) from Employee group by salary ) Order By salary desc limit 1 ;` – Ergest Basha Nov 02 '21 at 16:14
[The Rows Holding the Group-wise Maximum of a Certain Column](https://dev.mysql.com/doc/refman/8.0/en/example-maximum-column-group-row.html) – Álvaro González Nov 02 '21 at 17:17
@ErgestBasha it does not return anything. `Select max(id) from Employee group by salary` return all the Employees – myTest532 myTest532 Nov 03 '21 at 19:32

MySQL LIMIT inside a subquery

0 Answers0