How to get fifth highest salary from salary table by single query?

Asked Sep 11 '17 at 15:08

Active Sep 11 '17 at 15:13

Viewed 115 times

I can get second highest salary by this query. is it possible to use this query for calculate fifth highest salary??

SELECT max(salary) 
FROM [Employee] 
where (EmployeeID not in 
  (SELECT max(EmployeeID ) FROM [Employee] ))

please help me...

edited Sep 11 '17 at 15:13

asked Sep 11 '17 at 15:08

Barun Kumar

Your query appears unrelated to salaries. – Neville Kuyt Sep 11 '17 at 15:10
1

This is not a MySQL query. It looks like MS Access or SQL Server. – Gordon Linoff Sep 11 '17 at 15:10
But there is solution for this question i am finding that. if it is possible to use this query. – Barun Kumar Sep 12 '17 at 06:39

0 Answers0