select e.* from (select row_number() over (order by salary desc) as Rno,*

can anybody tell us, how to select 2nd max salary from
table.
my id is ashish.akk@gmail.com

Question Posted / naufal basheer

Answer Posted / naufal basheer

select e.* from
(select row_number() over (order by salary desc) as Rno,*
from employee)e
where e.Rno = 2

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How to integrate the ssrs reports in application?

936

What is user defined stored procedures?

880

How to modify the underlying query of an existing view?

937

What is the use of nvl work?

949

role of sql sever 2005 in database rather than any other database

1889

What are the new scripting capabilities of ssms? : sql server management studio

1004

What is nolock?

930

What does Master database contains?

1085

What are the properties of sub-query?

1027

What is history table in sql server?

896

How do I delete a sql server database?

988

How to implement service broker?

923

Do you know the policy based administration feature of sql server 2008?

909

How to update a field in SQL after ALTERING a row?

1183

what is the system function to get current user's user id? : Sql server database administration

951