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

What are subqueries in sql server? Explain its properties.

1019

What are the different types of collation sensitivity in sql server?

1113

What is a data source file?

975

How to create an inline table-valued function?

980

How to get a list of columns in a view using the "sp_columns" stored procedure?

1042

What is the bookmark lookup and rid lookup?

998

What is the difference between a primary key and a unique key? Are they the same?

1077

How do I find the sql server database version?

1008

What is function of CUBE ?

1046

How many databases Microsoft SQL server provides?

1091

What is transaction server implicit?

1012

How to use linked server?

1193

What is open database communication (odbc)?

1064

Explain what is lock escalation and what is its purpose?

932

explain different types of backups avaialabe in sql server? : Sql server database administration

969