Find the 3rd largest salary from the employees table in SQL.

Vikas Kumar Garg

11y2kSQL

I didn't get the query for fetching the third largest salary from the employees table. How to find out the 3rd largest or many more salary from the employee table in SQL?

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes11y ago
Accepted answer
I've just been having a look at the documentation for the SELECT command in MySQL:

http://dev.mysql.com/doc/refman/5.7/en/select.html

and I've noticed that the LIMIT clause has an option which takes 2 parameters rather than 1 which enables you to return a range of records. The first parameter is the offset from the first record (counting starts from 0 rather than 1) and the second parameter is the number of records to return.

So I think you should therefore be able to do this without using a sub-query at all:

SELECT DISTINCT salary FROM employees ORDER BY salary DESC LIMIT 2, 1
Anurag Singh11y ago
Use this and which highest salary you want just put the number instead of 3.

Select TOP 1 Salary from (SELECT DISTINCT TOP 3 Salary from Employees ORDER
BY Salary DESC) a ORDER BY Salary ASC
Vulpes11y ago
It's a pity we don't have the LIMIT clause in SQL Server.

It would save a lot of hassle with this and similar problems :)
Vikas Kumar Garg11y ago
Now I get my solution for the query.

Thanks for solving my problem.
Vulpes11y ago
The article is for SQL Server.

I don't think that MySQL supports the TOP keyword - you have to use LIMIT instead which is put at the end.

So, try this instead:

SELECT min(salary) FROM (SELECT DISTINCT salary FROM employees ORDER BY salary DESC LIMIT 3) AS A
Vikas Kumar Garg11y ago
http://www.c-sharpcorner.com/UploadFile/a20beb/find-the-3rd-or-nth-highest-salary-in-a-table-way-1/

I am using this link to find the result.

I write query like this:-

select min(salary) from (select DISTINCT TOP 3 salary from employees ORDER BY salary DESC) as A

But when I run this query, it gives an error:-

1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '3 salary from employees ORDER BY salary DESC) as A' at line 1
Vulpes11y ago
Check out this article:

http://www.c-sharpcorner.com/UploadFile/a20beb/find-the-3rd-or-nth-highest-salary-in-a-table-way-1/