how to find nth highest salary
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 |
Post New Answer View All Answers
What are the different index configurations a table can have?
When would you use sql joins?
What are the difficulties faced in cube development? : sql server analysis services, ssas
Write down the syntax and an example for create, rename and delete index?
While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?
What is conditional split?
What is constraints and its types?
Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?
how to define testing of network layers? : Sql server database administration
What is page-level compression?
Can you tell me about the concept of ER diagrams?
What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?
Explain stored procedure?
What is a db view?
How do I find the default sql server instance?