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 acid db?

880

Why functions are used in sql server?

957

Explain difference between cross join and full outer join?

1003

If you want to send some data from access database to sql server database. What are different component of ssis will you use?

976

What is fill factor and pad index?

1007

Explain concepts of analysis services?

954

What are the aggregate and scalar functions?

1055

What is a db view?

891

Who is the owner of a schema in ms sql server?

1071

What are the types of containers in ssis?

1168

Explain stored procedure?

1047

what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration

990

What is sql stored procedure?

1084

Can we install sql server 2016 on windows 7?

1127

How to recover from sql injection? : sql server security

1007