Another way is:: SELECT sal FROM sal a WHERE n = ( SELECT count(*) FROM

how we can find nth max salary from an employe table by
using my sql?

Question Posted / jithu

8 Answers
14265 Views
I also Faced
E-Mail Answers

Answer Posted / 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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to calculate the difference between two dates?

1065

Tell us something about heap tables?

990

What is datadir?

882

Can I use mariadb instead of mysql?

924

In how many ways we can retrieve the data in the result set of MySQL using PHP? What is the difference between mysql_fetch_object and mysql_fetch_array ?

1073

What is the limit of mysql database?

962

How to find second highest salary from a table?

1022

Can mysql function return a table?

1098

What is the maximum no of columns a table can have?

913

What does "i_am_a_dummy flag" do in mysql?

960

How to store binary data in mysql?

1003

How to create a trigger in mysql?

938

What is pdo :: fetch_assoc?

905

Write a query to count the number of rows of a table in mysql.

937

What is slow query log in mysql?

1110