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

4 Answers
5519 Views
I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is control file used for?

1226

What is the difference between post-database commit and post-form commit?

1210

20. Using a set operator, display the client number of all clients who have never placed an order.

2199

What is an Oracle Instance?

1134

What is the difference between online and offline backups?

1070

Is oracle a language?

955

What happens to the data files if a tablespace is dropped?

1072

How to use "in" parameter properly?

1082

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

2141

Give the various rollback segment states.

1060

Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??

1748

Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun

2193

What is tns name?

988

What is the difference between 10g OEM and 11g OEM?

975

How to run create database statement?

1044