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

Does transparent data encryption provide encryption when transmitting data across the network?

800

hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.

1733

Explain what is raid and what are different types of raid levels?

702

How can you find out how many rows returned in a cursor?

750

How do I schedule a sql server profiler trace?

692

Describe how to use linked server?

689

What is simple indexing method?

745

How to concatenate two strings in SQL Server.

774

How to find tables without indexes?

776

Explain Capacity planning to create a database? and how to monitor it?

3939

How many types of dimensions are there and what are they? : sql server analysis services, ssas

765

What is the use of partition by in sql server?

663

how to invoke a trigger on demand? : Sql server database administration

724

What are secondary xml indexes?

777

What are a scheduled jobs?

692