SELECT MAX(salary)FROM employee WHERE salary NOT IN (SELECT TOP 1 salar

how to find nth highest salary

Question Posted / arun

Answer Posted / arun

SELECT MAX(salary)FROM employee WHERE salary NOT IN
(SELECT TOP 1 salary FROM employee ORDER BY salary DESC)

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is a partition key?

1033

Does sql server 2000 full-text search support clustering?

915

What is a fill factor?

1141

What are dml triggers and types of dml triggers?

1032

Which are ddl commands?

1119

role of sql sever 2005 in database rather than any other database

1992

What is autocommit mode in sql server?

1269

What are the advantages of log shipping?

1039

Tell me what is difference between view and materialized view?

985

How many types of triggers in sql server?

1094

Explain different types of locks in sql server.

1131

What is the architecture of ms sql reporting service?

1027

While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?

113

How to find table changes in sql server?

1177

How to create function without parameter in sql server?

1111