write query for fourth maximum salary from employee table
- 14 Answers
- 21992 Views
- Mind Tree, SP Software, I also Faced
- E-Mail Answers
Answer Posted / raman
select top 1(esal) from (select top 2(esal) from employee order by esal desc) employee order by esal asc
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the federation in sql azure?
How do you improve the performance of a SQL Azure Database?
Explain ranking functions?
How to modify an existing user defined function?
Define self join in sql server joins?
Explain the disadvantages of cursors?
What is a document index?
Explain what is analysis service repository?
How will you decide the active and passive nodes?
How to Check if table exists in sql server?
What is the use of sql profiler in sql server 2012?
What do you understand by replication in sql server? Mention the different types of replication in sql server.
What are the differences between lost updates and uncommitted dependencies?
you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration
What is the difference between a function and a trigger?
