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

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

Please Help Members By Posting Answers For Below Questions

What is user in mysql?

831

What is difference between unix timestamp and mysql timestamp?

969

What are the differences between char and nchar?

1031

How can you retrieve a particular number of records from a table?

912

What is difference mysql and mysqli?

926

What is sharding in mysql?

932

How you can create a trigger in mysql?

954

How do I start mysql client?

923

What is mysql data directory?

946

How to enable or disable a row of a table using MySQL in struts?

4056

What is the data source name for mysql?

910

how to show all records starting with the letters 'sonia' and the phone number '9876543210' limit to records 1 through 5.

874

Why do we use mysql?

896

Why is mysql used?

904

What is text in mysql?

870