how to find nth highest salary
Answer Posted / vijay
select top 1 sal
from
(select top 3 sal
from emp
order by sal desc )sub
order by sal
| Is This Answer Correct ? | 12 Yes | 24 No |
Post New Answer View All Answers
How to run queries with sql server management studio express?
What is data source in connection string?
What is sub-query in sql server? Explain its properties.
What are window functions in sql server?
what is a deadlock? : Sql server database administration
When you should use a low fill factor?
Do I need a report server to run reports in my application?
What are three major types of constraints?
Tell me about joins in database system and explain each in detail.
What stored by the msdb?
how to control the amount of free space in your index pages? : Sql server database administration
What are the types of sql server?
What is report subscription?
Explain indexes disadvantages?
What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?