select distinct(salary) from employee order by salary desc limit n-1,1

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

Question Posted / ksam

Answer Posted / ksam

select distinct(salary) from employee order by salary desc
limit n-1,1

Is This Answer Correct ?

6 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How to show table structure mysql?

1014

change column name and make a unique column so we get no dupes.

984

What is the maximum size of table in mysql?

1030

Is mysql running ubuntu?

995

What is clob in mysql

949

How does mysql store binary data?

970

What is the difference between having and where clause in mysql? Explain

1021

How many rows we can insert in a mysql table?

966

Differentiate CHAR_LENGTH and LENGTH?

1003

Where is the mysql database stored?

916

How much does mysql cost?

926

What is mysql routine?

940

Is mysql same as mariadb?

911

What is tee command in mysql?

958

What is blob datatype in mysql?

936