with x as(select row_number over(order by sal desc) as rid,* from emp) sel

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

Question Posted / prasad237

Answer Posted / prasad237

with x as(select row_number over(order by sal desc) as rid,* from emp)
select * from x where rid=n
we can retrieve nth max sal

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Does a server store data?

957

Name three of the features managed by the surface area configuration tool? : sql server security

1034

What are the advantages dts has over bcp?

1052

Difference between aggregate functions of sql?

1149

What is public role in sql server?

1216

Explain something about security and SQL Azure?

134

What are the types of dml?

1032

what is difference between NULL and ISNULL in SQL Server 2008?

1058

Define Business Edition in SQL Azure?

102

What are the advantages of passing name-value pairs as parameters?

1220

Is sql server free?

977

What is the library index called?

1113

What are the difference between clustered and a non-clustered index?

1091

What is temporary table in sql server? Why we use temp table?

995

What is the report builder?

143