select *from(select ename,sal,row_number()over(order by sal desc) rk from e

Select the Nth lowest value from a table?

Question Posted / mahesh

Answer Posted / mahesh

select *from(select ename,sal,row_number()over(order by sal desc) rk from emp) where rk=2;

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How do you store pictures in a database?

1008

What is recovery manager(rman) backup in Oracle?

1185

Why does for update in oracle 8 cause an ora-01002 error?

1003

What is the difference between a user and a schema in oracle?

1034

How to pass a parameter to a cursor in oracle?

1186

How to connect to a remote server?

1128

What to do if dba lost the system password?

1173

How do I find the database name in oracle?

1039

How to retrieve the count of updated rows?

1128

types of indexes and the rationale behind choosing a particular index for a situation.

2510

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1908

How to define an oracle cursor variable?

1032

defination of bitmap index

2131

What are the ways tablespaces can be managed and how do they differ?

2368

What are the different types of failures that occur in Oracle database?

1067