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

Select the Nth lowest value from a table?

Question Posted / basanti

4 Answers
5657 Views
I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is control file used for?

1303

What is data block in Oracle?

1151

How to create a new view in oracle?

1129

Does oracle database need java?

1070

How to convert characters to times in oracle?

1071

How to get a list of all background sessions in the database?

1041

Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.

1894

How to convert raw data type into text in oracle? Explain

1047

How to apply filtering criteria at group level in oracle?

1087

Point out the difference between user tables and data dictionary?

1038

What is transport network substrate (tns) in oracle?

1096

What is meant by an index?

1224

Explain the blob datatype?

1125

What is a directory object?

1137

Explain compound trigger in oracle?

1091