Select top 1 salary from (select top 4 salary from tbl

write query for fourth maximum salary from employee table

Question Posted / yogendra barode

Answer Posted / yogendra barode

Select top 1 salary from (select top 4 salary from tbl_emp
order by salary desc) temp_tbl order by asc

Is This Answer Correct ?

5 Yes

5 No

Please Help Members By Posting Answers For Below Questions

What is the difference between a check constraint and a rule?

1160

What is view in sql?

863

What are the triggers in sql?

1041

What are the recovery models for a database?

1066

What is scd (slowly changing dimension)? : sql server analysis services, ssas

966

Explain in brief about Microsoft SQL server?

1029

What are locks in sql?

938

Do you know what is fill factor and pad index?

953

what are triggers? : Sql server database administration

880

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

868

what is a join and explain different types of joins? : Sql server database administration

925

Detail about query optimizer?

1043

In which tcp/ip port does sql server run? Can it be changed?

957

How display code or Text of Stored Procedure using Sql query in Sql Server ?

1084

Can you explain the disadvantages/limitation of the cursor?

928