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 the importance of concurrency control?

1175

What are the different ways you can create databases in sql server?

1041

what is package and it uses and how can u call a package

1949

Where cross join is used?

902

What is updatable resultset?

932

What is the purpose of linked server configuration in sql server?

988

How to enable/disable indexes?

1012

Where the sql logs gets stored?

932

What is multi-statement table-value user-defined function?

932

Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?

940

Explain what is use of dbcc commands?

987

What are binary string data types in ms sql server?

1168

What is exporting and importing utility?

1015

Does any body please help me what question's have asked for SSRS in the interview?

2086

What are “lost updates”?

948