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 is the differences between internal requisition and internal sales order?

2661

WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?

3066

What does appl_top directory contain?

1124

What are the benefits of using soa architecture?

1252

tell me the scenarios of the independent in reports

2504

q)what are the validations in sql*loader

2406

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

5900

What are the different components of soa suite?

1209

CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP

2634

Tell me how to debug the report?

1125

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

1125

please send me forms, xml pulisher questions,answers

2113

What is instead of trigger in where we will use?

1178

What is a flexfield? List out its types.

1173

Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?

2617