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

Does mysql use t sql?

917

How to delete the repeated records from a table?

907

How many sql ddl commands are supported by 'mysql'?

1074

What is procedure in mysql?

881

What is delimiter $$?

911

How do I connect to mysql database?

963

Which mysql function is used to concatenate string?

1397

How to dump a table from a database.

962

How to enter boolean values in sql statements?

1065

What is select query in mysql?

858

Is mysql is a programming language?

936

What sql does mysql use?

868

all the queries used in sql

2589

What is mysql_pconnect?

841

What is the difference between timestamp and datetime in mysql?

976