select * from (select *,row_number()over (order by salary asc)as a from Em

Please get the 4 th maximum salary from a table without
using any sql keyword (TOP,MAX are mot allowed)

Question Posted / gajendra

Answer Posted / gajendra

select * from (select *,row_number()over (order by salary
asc)as a from Employee)as b where b.a=4

Is This Answer Correct ?

8 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is efficiency data?

953

What are the disadvantages of using the stored procedures?

1110

What are system databases into sql server (2005/2008)?

1004

What functions can a view be used to performed?

1061

what stored procedure can you use to display the current processes? : Sql server administration

1016

List all types of constraints in sql server?

1050

What is use of attributehierarchyenabled? : sql server analysis services, ssas

1243

What is the difference between writing data to mirrored drives versus raid5 drives

938

Can we insert data if clustered index is disabled?

946

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

968

What is in place upgrade in sql server?

1048

Explain hostprotectionattribute in sql server 2005?

1042

How many types of database relationship in sql server?

1060

How to send email from database?

1018

What is nested transaction?

1106