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

tell me the scenarios of the independent in reports

2583

what is the difference between request group and request security in oracle apps?

5836

What do you understand by soa and what are the benefits of using this architecture?

1046

How many schemas we have? how many you have used?

2027

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

2629

In hierarchical structure of a database? we have write query from where we should start?

2203

Can you differentiate between mediator and osb?

1107

What does appl_top directory contain?

1095

Which oracle apps version you are very confident in?

1187

Do you know where we can check the status of po?

1229

How to move the one file from one instance to another instance? And your scripts also?

1084

What is oracle soa suite?

1196

What do you understand by soa?

1117

pls send me out bound code of supplers,site,bankiformation code pls as soon as

2231

What is count(*) from po_vendors(any table)?

1057