SELECT TOP 1 salary FROM ( SELECT DISTINCT TOP n salary FROM employee O

how to find nth highest salary

Question Posted / anija

Answer Posted / anija

SELECT TOP 1 salary
FROM (
SELECT DISTINCT TOP n salary
FROM employee
ORDER BY salary DESC)
ORDER BY salary

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the recursive stored procedure in sql server?

1027

How to loop through result set objects using odbc_fetch_row()?

985

What is the return type of executeupdate ()?

910

What is global temp table?

1001

How does using a separate hard drive for several database objects improves performance right away?

937

What are user-defined functions (udfs) in sql server?

995

what is create database syntax? : Sql server database administration

1113

Mention the 3 ways to get a count of the number of records in a table.

980

What do you understand by hotfixes and patches in sql server?

997

What are the restraints imposed on the table design by a merge replication?

1041

How do you delete a data source?

1013

How can a database be repaired?

997

How do I completely remove sql server instance?

1107

What is ems sql management studio? : sql server management studio

1114

what are different types of backups available in sql server? : Sql server database administration

942