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

How do I edit a trigger in mysql?

872

Is number a datatype in mysql?

925

What is a heap table?

930

Write command to import an mysql file?

1013

Can you tell the difference between ereg_replace() and eregi_replace()?

1018

Why mysql is so popular?

943

What are the 'mysql' command line arguments?

988

How to use rank function in mysql?

956

What is a procedure example?

907

What is orm in mysql?

886

How do you say mysql?

866

What is insert query in mysql?

886

What is heap table?

1012

What is acid in mysql?

830

What is default schema in mysql?

916