write query for fourth maximum salary from employee table
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 difference between the application object and session object?
How many types of keys are there?
Is ssrs support other database except ms sql server?
Explain subquery and state its properties?
What is ms sql server index?
How to create a testing table with test data in ms sql server?
Do you know clustered and non-clustered index?
What is Federation and Federation Member?
can we have a nested transaction? : Sql server database administration
Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
What is the difference between left and right outer join?
What is the federation in sql azure?
What is the use of toad or sqldbx.?
What are the diifferences between the ms sql server vs mysql?
You want to use bids to deploy a report to a different server than the one you chose in the report wizard. How can you change the server url?