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

Explain oracle’s system global area (sga).

615

What is the difference between count (*), count (expression), count (distinct expression)?

552

Which is faster join or subquery in oracle?

531

what is the scenario where you take the database to NoArchivelog mode?

1828

How to shutdown your 10g xe server?

612

How to establish administrator authentication to the server?

556

How to use "in out" parameter properly?

610

How to write date and time literals in oracle?

551

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

1856

What is a trace file and how is it created in oracle?

546

What is the usage of control file in oracle?

603

What is background process in Oracle?

622

Is java required for oracle client?

544

How to write numeric literals in oracle?

602

How to use windows user to connect to the server?

530