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
Explain what is it unwise to create wide clustered index keys?
Explain magic tables in sql server?
List all types of constraints in sql server?
What is table join?
List out the different types of locks available in sql server?
How to count rows with the count(*) function in ms sql server?
What are the advantages of log shipping?
Tell me what is fill factor?
what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
Which language is supported by sql server?
What is primary key index?
Explain the concept of view and Types of views in SQL server?
Do you know hot add cpu in sql server 2008?
What is public role in sql server?
What are views used for?