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 are sparse columns?

991

Do you know the cursor types?

1145

Explain can you implement data mining in ssrs?

158

Explain what is the use of custom fields in report?

898

explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

886

What is the difference between drop table and truncate table?

912

Is it possible to call a stored procedure within a stored procedure?

950

Is null vs coalesce?

849

What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio

1122

What is the cartesian product of the table?

943

Why I am getting this error when dropping a database in ms sql server?

1059

What is a database in ms sql server?

1038

What are unicode character string data types in ms sql server?

1219

What are the purpose of Normalisation?

1039

What is the difference between push and pull subscription? : sql server replication

1196