select * from(select rownum,ename from employee order by rownum desc) where

Select the Nth lowest value from a table?

Question Posted / basanti

Answer Posted / basanti

select * from(select rownum,ename from employee order by rownum desc) where rownum<=5;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain the use of record option in exp command.

949

Explain the use of grant option in exp command.

1006

What privilege is needed for a user to create tables in oracle?

902

how to make an oracle object

2292

What is analyze command used for?

1012

What is SQL access advisor in Oracle?

1137

What is a read only transaction in oracle?

973

What are the data types in oracle?

981

Where do you use decode and case statements?

945

How does oracle handle read consistency?

1052

Which environment variables are absolutely critical in order to run the OUI?

2071

What is the difference between online and offline backups?

973

Explain what are the uses of rollback segment?

961

What happens if recursive calls get out of control?

1000

What is a database schema in oracle?

1055