select max(salary) from Employee where salary not in(select top (n-1) sala

how to find nth highest salary

Question Posted / guru

Answer Posted / guru

select max(salary) from Employee where salary not in(select
top (n-1) salary from Employee order by salary desc)

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are the different index configurations a table can have?

974

When would you use sql joins?

974

What are the difficulties faced in cube development? : sql server analysis services, ssas

1053

Write down the syntax and an example for create, rename and delete index?

992

While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?

1053

What is conditional split?

1092

What is constraints and its types?

961

Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?

986

how to define testing of network layers? : Sql server database administration

985

What is page-level compression?

974

Can you tell me about the concept of ER diagrams?

1094

What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?

1155

Explain stored procedure?

1065

What is a db view?

910

How do I find the default sql server instance?

952