In a table their 20 records.I had update 6 records???How
can see and retrieve particular 6 records.i.e.,Latest
updated.
- 10 Answers
- 15314 Views
- HCL, TCS, I also Faced
- E-Mail Answers
Answer Posted / orchid
Since the following sql
select * from aa
where rownum <= 6
order last_updated_date desc
will return random 6 rows and then the
order by 'last_updated_date desc' will only apply to
selected 6 records, so you won't get latest updated 6
records.
Please correct me if I was wrong.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
what are the prerequisites for costing transactions?
WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?
How can a process be deployed in soa?
Suppose for report I have to parameters those are from_date and to_date, so to_date should be greater when compare to from_date, if we are giving to_date is lessthen it must shows some error how we will make?
How is choreography different from orchestration?
What do you understand by a set of books?
Explain what are the tables of auto invoice?
what are the different transaction clauses in AR?
What do you understand by concurrent programs?
Do you know where we can check the status of po?
List the types of flexfield?
Can you differentiate between mediator and osb?
how can i print random rows in plsql table
Is soa a part of oracle fusion middleware?
is it possible to run the interface without using oracle apps?
