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

How do I find the query plan in sql server?

543

Explain timestamp datatype?

552

What is optimistic concurrency?

561

What is a matrix in ssrs?

101

Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

522

What are data regions?

Can we delete data from a view?

540

How do you know if sql server is running on your local system?

538

Explain primary key?

539

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

651

What do you mean by a Composite primary key?

588

Can you explain different types of joins?

545

What is the log shipping?

580

I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?

596

What is the use of group by clause?

524