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 difference between temp table and cte?

1014

What are the 3 types of schema?

1110

How sql server executes a statement with nested subqueries?

1026

What are the different types of indexes?

1114

Can we do dml on views?

952

Why is there a performance difference between two similar queries where one uses union and the other uses union all?

1030

Explain acid?

1076

Explain about temporary stored procedure?

1016

List the various tools available for performance tuning?

887

What is the difference between update lock and exclusive lock?

973

If the job running very slow what is the action you do

1890

What is a field name?

957

how can a database be repaired? : Sql server administration

971

What the different topologies in which replication can be configured?

1085

What are the character string functions supported by sql server 2005?

1012