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 do you register report in oracle apps?

622

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

5036

tell me the scenarios of the independent in reports

2043

q)what are the validations in sql*loader

1736

How can a process be deployed in soa?

692

In support project one ticket alloted which steps follows manualy tell me ?

2219

What are the different components of soa suite?

718

how can i print random rows in plsql table

1930

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

1975

What do you understand by soa and what are the benefits of using this architecture?

617

Explain what are the tables of auto invoice?

640

What are the Standard Reports and Forms in HRMS?

1766

what is global tempory table?

6285

Plz anybody send me Technical specification for AP Interface

2006

What do you understand by soa?

687