Select salary from employees order by salary desc limit n-1,1;

how to find nth highest salary

Question Posted / amit

Answer Posted / amit

Select salary
from employees
order by salary desc
limit n-1,1;

Is This Answer Correct ?

2 Yes

3 No

Please Help Members By Posting Answers For Below Questions

Explain syntax for dropping triggers?

905

How to Sync Two SQL Azure Databases?

119

Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many

907

How to create a view using data from another view?

927

In which tcp/ip port does sql server run? Can it be changed?

959

How except clause is differs from not in clause?

921

What are commonly used odbc functions in php?

991

Can an automatic recovery be initiated by a user?

961

What is 'write-ahead log' in sql server 2000 ?

1018

How can we rewrite sub-queries into simple select statements or with joins?

943

What is the difference between online clustering and Offline clustering?

2386

What is the default port for SQL Server over a firewall?

1053

Does the order of columns in update statements matter?

881

Where can you find the error log information? : sql server database administration

994

What is the difference between rank and dense_rank?

1035