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 the use of mysql workbench?

1024

How can we run batch mode in mysql?

1069

What is datatype in mysql?

957

How do I completely remove mysql from windows?

984

What is pragma exception?

980

What is the use of mysql_fetch_array () function in php?

948

List some comparisons operators used in mysql?

994

How to define numeric 9(3) in db2 table without decimal point??

2860

How can I remotely connect to mysql database?

936

Is mysql still relevant?

913

Where is mysql used?

1002

How to decrement dates by 1 in mysql?

1019

How do I start mysql client?

973

Does mysql use tcp or udp?

923

What is mysql data directory?

1009