select *from (select *from emp 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 / harinath

Answer Posted / harinath

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

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to create a purchase order without a requisition?

1254

List the various types of value set.

1122

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

2113

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

2133

List the types of flexfield?

1087

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

2258

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

2158

What is sca and how is it useful?

1171

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

1361

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

1140

how can develope the po variance and po summary report? with tables mandatory columns and query please?

2437

What do you understand by a set of books?

1154

How do you register report in oracle apps?

1136

Can u give the Documentation of Custom.pll in oracle apps

3518

please send me forms, xml pulisher questions,answers

2160