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

In which language it is written?

520

What is the storage engine for mysql?

496

What is difference between oracle sql and mysql?

491

What do ddl, dml, and dcl stand for?

483

Where is mysql data stored?

478

What is the default port of mysql server?

507

What does do in mysql?

478

Is postgresql better than mysql?

511

What is InnoDB?

562

What do we use to remove duplicate records while fetching a data in mysql ?

513

What is mysql root?

487

How to copy data from one server to another using php?

528

What are Heap tables?

837

What is text in mysql?

495

What is pdo in php mysql?

497