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 happens in oracle commit?

559

What are the restrictions in a oracle read only transaction?

560

Is there an oracle sql query that aggregates multiple rows into one row?

540

In which language oracle has been developed?

639

What are the attributes that are found in a cursor?

639

What is the relation of a user account and a schema in oracle?

577

What is the maximum limit on the number of columns in a table?

545

How to define a procedure inside another procedure?

538

What suggestions do you have to reduce the network traffic?

538

In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?

1773

Can we use bind variables in oracle stored procedure?

483

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

564

What are the extensions used by oracle reports?

569

Hi friends can u send the oracle 9i full version download link?????????????? please reply ?

1435

What is hot backup and logical backup?

599