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

What is a flexfield? List out its types.

1112

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

1125

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

3577

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

3424

What are file in oracle.

2182

Can you explain the difference between architecture followed in 10g & 11g?

1020

how do you describe O2C along with tables

2727

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

2171

What is instead of trigger in where we will use?

1128

tell me the scenarios of the independent in reports

2564

what is the differences between internal requisition and internal sales order?

2604

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

2044

what are the balancing segments in AR?

2042

List the types of flexfield?

993

is it possible to run the interface without using oracle apps?

1931