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 are rows and columns?

955

What is implicit mode in sql server?

1030

Where can you find the error log information? : sql server database administration

972

Explain about unique identifier data type in sql server?

861

What is abstracting periodical?

896

explain declarative management framework (dmf) in sql server 2008?

950

How do I change my passwords (database, LDAP, and so on) without causing an outage?

1019

Name few of the dcl commands in sql?

951

Explain sub-query?

902

Explain sql server authentication modes?

1077

What is the difference between getdate and sysdatetime?

942

Can we add a cpu to sql server?

960

What guidelines should be followed to help minimize deadlocks?

870

What is field in algebra?

983

What happens if null values are involved in boolean operations?

942