select top 1(esal) from (select top 2(esal) from employee order by esal des

write query for fourth maximum salary from employee table

Question Posted / raman

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

Please Help Members By Posting Answers For Below Questions

What is the difference between the application object and session object?

1032

How many types of keys are there?

992

Is ssrs support other database except ms sql server?

133

Explain subquery and state its properties?

992

What is ms sql server index?

1055

How to create a testing table with test data in ms sql server?

1043

Do you know clustered and non-clustered index?

952

What is Federation and Federation Member?

can we have a nested transaction? : Sql server database administration

1028

Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

1004

What is the difference between left and right outer join?

1043

What is the federation in sql azure?

What is the use of toad or sqldbx.?

1121

What are the diifferences between the ms sql server vs mysql?

1141

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?

151