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

What is microsoft sql server?

956

Explain where clause?

977

How to resolve the orphan use problem? : sql server security

999

What are sql servers used for?

1022

Can an entity have two primary keys?

964

What do you mean by data manipulation language?

993

Define views.

992

Can sub report data source be different from that of the parent report?

141

What are binary string data types in ms sql server?

1254

What is the security principal at the server level that represents your session?

1000

Does partitioning improve performance?

951

What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?

951

What are different types of join?

1296

between cast and convert which function would you prefer and why?

941

What are horizontal and vertical scaling?

170