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 to add the custom code in Report?

129

do you know how to configure db2 side of the application? : Sql server database administration

1097

What does set rowcount do?

961

whats the maximum size of view state??

2248

What is the difference between dataadapter and datareader?

1058

Are null values the same as that of zero or a blank space?

1088

what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?

2025

Differentiate between sql temp table vs table variable?

927

What is abstracting periodical?

991

What is key set driven?

1009

Is INSTEAD OF trigger directly applicable to Table ?

1066

How do I create an extended event in sql server?

1002

Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?

125

What do you mean by collation recursive stored procedure?

1106

How can we improve performance by using SQL Server profiler?

1108