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

Plz anybody send me Technical specification for AP Interface

2032

Is soa a part of oracle fusion middleware?

619

Which oracle applications pl/sql standard apis you are familiar, have you used most of them?

644

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

5073

WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?

2603

Do you know what are user profiles in apps. Any examples you can give?

673

what is pay run id ?

1721

what is global tempory table?

6335

where to define interorganization transaction charges and what are the different options?

1972

List the various types of value set.

633

Explain what are the tables of auto invoice?

652

How can a process be deployed in soa?

717

How can we import the data into a database using sql * loader?

691

what are the prerequisites for costing transactions?

2645

Can you differentiate between mediator and osb?

640