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 automatically create a log when an exception is being received into SQL Server?

1256

Does sql server use java?

1049

How to provide login information for a new odbc dsn?

1033

Define Wed Edition in SQL Azure?

100

How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.

3853

Can two tables share a primary key?

1003

What is the difference between sdf and mdf?

1280

What is subreport?

141

What is use of attribute hierarchy optimized state? : sql server analysis services, ssas

1045

What are drillthrough reports?

155

How much is a sql server license?

931

What is ms sql server service broker?

967

Can select statements be used on views in ms sql server?

1046

What are security principals used in sql server 2005?

953

List some advantages and disadvantages of stored procedure?

1005