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

How do I determine how many instances of sql server are installed on a computer?

1008

What is partition, how will you implement it? : sql server analysis services, ssas

1056

Define tempdb database?

1006

What does <> symbol mean?

983

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

1077

What is normalization and denormalization in sql server?

1021

What is the concept of optimization?

1062

What are the differences between lost updates and uncommitted dependencies?

1086

Is it ok to shrink transaction log?

1009

Do you know what are the differences between lost updates and uncommitted dependencies?

1087

What are the security related catalog views? : sql server security

955

Are resultset updatable?

962

What is the difference between having clause and where clause in sql server?

1106

What is normalization? Explain its different types?

1100

what are isolation levels? : Sql server database administration

1000