select max(salary) from Employee where salary not in ( select top 5 Sal

how to find nth highest salary

Question Posted / saurabh

Answer Posted / saurabh

select max(salary) from Employee where salary not in (
select top 5 Salary from ( select distinct Salary from
Employee order by Salary desc))

Is This Answer Correct ?

0 Yes

11 No

Please Help Members By Posting Answers For Below Questions

What are subqueries in sql server?

1125

what's new in sql server 2016?

951

How can you list all the columns in a database?

934

Why main is user defined function?

1014

How to check if a table is being used in sql server?

965

Does sql server 2000 full-text search support clustering?

870

Explain “not null constraint” in sql server?

1039

What is the difference between DATETIME2 and DATETIME?

1085

what is the difference between openrowset and openquery?

1089

What is the difference between for auto and for nested?

1005

What is the stuff?

1005

What are different types of collation sensitivity?

989

Explain about Views?

1072

How to recreate an existing index in ms sql server?

1059

What is awe?

1014