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

How do I setup a local sql server database?

1012

How to receive returning result from a query?

1129

what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration

1057

What is the order in which the sql query is executed?

944

What is difference between stored procedure and user defined function?

1115

What is a system database and what is a user database?

1090

Write a SQL queries on Self Join and Inner Join.

1050

Explain how you can configure a running aggregate in SSRS?

163

What is DCL?

1056

Define ACID properties in a Database?

1064

How to rename an existing table with the "sp_rename" stored procedure in ms sql server?

1033

Can you explain different types of joins?

941

What is the concept of optimization?

1062

what kind of lan types do you know? : Sql server database administration

982

What is the security principal at the database level that represents your session?

945