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
5434 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

How to end the current transaction in oracle?

1012

What is a table index in oracle?

1106

What is an oracle user account?

964

How to write a query with an inner join in oracle?

1015

What is the dynamic sql in oracle?

1049

src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

1673

How to drop an existing view in oracle?

931

What is meant by recursive hints in oracle?

1067

What is Java Pool in Oracle?

1144

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

2148

What is data block in Oracle?

1086

Explain the types of exception?

1119

How does Oracle guarantee data integrity of data changes?

2369

How to do a full database export?

1081

How many types of tables are there in oracle?

1042