select * from aa where rownum <= 6 order 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 / kavitha

Answer Posted / kavitha

select * from aa
where rownum <= 6
order last_updated_date desc

Is This Answer Correct ?

15 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What are the different components of soa suite?

911

Which oracle apps version you are very confident in?

923

What does appl_top directory contain?

842

List of all the modules under Manufacturing, Finance and Distribution in oracle applications?

1959

What are the Standard Reports and Forms in HRMS?

1960

Do you know what is applysys in oracle application database schema, what is apps?

923

What is oracle soa suite?

957

please any one provide the oracle erp technical interview questions on modules(PO,AP,AR,INV,GL,OM)wise to my mail id..narendra_609@yahoo.co.in

3322

If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?

1830

What are the benefits of using soa architecture?

898

Is soa a part of oracle fusion middleware?

805

In sequence i want to 11 and 15th values how we will write?

1781

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

812

how to print multi lay outs,muti currency,muti language in xml publisher

11463

what are the balancing segments in AR?

1831