select * from (select * from aa order by last_updated

In a table their 20 records.I had update 6 records???How
can see and retrieve particular 6 records.i.e.,Latest
updated.

Question Posted / orchid

Answer Posted / orchid

select * from (select * from aa
order by last_updated_date desc)
where rownum <= 6;

Is This Answer Correct ?

5 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What are the different components you should consider while defining a responsibility in oracle apps?

737

what is the differences between internal requisition and internal sales order?

2260

What are the Standard Reports and Forms in HRMS?

1855

is it possible to run the interface without using oracle apps?

1601

what are the prerequisites for costing transactions?

2748

can we get profile values in report without using user exists is it possible how?

2407

What is a value set? List its various types.

736

Explain what are the tables of auto invoice?

737

Can you define an erp system?

762

WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?

2689

In support project one ticket alloted which steps follows manualy tell me ?

2283

In oracle application how do you debug or trace errors?

729

What does appl_top directory contain?

739

Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?

1782

how can i print random rows in plsql table

2034