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

What is sequence?

1087

How will you identify oracle database software release?

1018

How can we create the complete backup of data in the oracle.

2162

How to use "in" parameter properly?

1078

What is the difference between alert log file and tarce file ?

2179

Explain the use of parfile option in exp command.

1075

What are the different types of synonyms?

1144

Can a formula column be obtained through a select statement ?

2334

How to assign values to variables?

1113

How to write a left outer join with the where clause in oracle?

1090

How to test null values?

1115

How to count groups returned with the group by clause in oracle?

1084

What is a procedure in oracle?

1208

How to assign values to data fields in record variables?

1039

How to use "out" parameter properly?

1088