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

Mention the command used to rename the database.

1016

Can foreign key be duplicate?

1069

What do you know about normalization and de- normalization?

933

How to create an identity column?

1228

What is the difference between push and pull subscription? : sql server replication

1223

What command is used to rename the database?

1021

How to connect php with different port numbers?

1092

What is Federation and Federation Member?

What is the maximum rows in sql server table?

921

What command do we use to rename a database?

1086

List few advantages of stored procedure.

983

Why union all is faster than union?

920

What is difference between oltp and olap?

1060

What is the name of the Database which IBM mainframe uses?

989

What is a not null constraint?

1040