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 can delete duplicate records in cte in sql server?

913

What is Sqlpaging in SqlServer 2005 ?

1016

Why should we go for stored procedures? Why not direct queries?

1029

What is index fragmentation in ms sql server?

1025

What is the purpose of data source?

957

How can you control the amount of free space in your index pages?

1012

Difference between Logical Page and Physical Page in SSRS.

460

Explain what are the basic functions for master, msdb, model, tempdb databases?

913

Explain about Views?

1011

What are the features of Embedded SQL

1077

how many clustered indexes can be created on a table? : Sql server database administration

1068

What is join query?

840

Does partitioning improve performance sql server?

900

How do you create type- insensitive operator?

995

What is database architecture? : SQL Server Architecture

977