how we can find nth max salary from an employe table by
using my sql?
Answers were Sorted based on User's Feedback
Answer / pious deepak
select salary from employee
order by salary desc limit n-1, 1
Is This Answer Correct ? | 29 Yes | 4 No |
Answer / whatinaname
select max(salary) from employee
order by salary desc limit n-1, 1
Is This Answer Correct ? | 14 Yes | 2 No |
Answer / ksam
select distinct(salary) from employee order by salary desc
limit n-1,1
Is This Answer Correct ? | 6 Yes | 2 No |
Answer / nivedita
select max(salary) from employee order by salary desc limit 1;
Is This Answer Correct ? | 3 Yes | 0 No |
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 |
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 |
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 |
What different Stored Objects are supported in MySQL?
How can I insert images into a Mysql database?
What are the disadvantages of stored procedures?
how to display nth highest salary from a table in a mysql query? : Mysql dba
What is trigger in mysql with example?
What are the advantages of mysql in comparison to oracle?
How do we delete a row in a table?
How to create a table?
how to delete duplicate rows in sql server 2005?
How can I change database in mysql?
Where the database is stored in mysql?
What command is used to delete the data from the table without deleting the table structure?