Interested to Buy Any Domain ? << Click Here >> for more details...
A Table has 10,000 records,How can i get latest 10 dates
from the table.so that i can only store those 10 records
in to my Resultset Object,to reduce load on my app?
- 7 Answers
- 11555 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / sonu
Answer of Ravikumar.s is almost write but there is slightly
mistake, he should write 'desc' keyword instead of 'asc'
because question for latest records not for the oldest
records. So, the correct answer is
select * from (select * from tablename order by datecolumn
desc) where rownum<=10;
One keyword makes the statement and result write or wrong
so, use these carefully.
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
can u pls share responsibilities for production how to environment in odi?and how to generate report ?
Are These Dff's Flexible?
How would you go about increasing the buffer cache hit ratio?
What is the technical flow associated with P2P or Procure to Pay cycle like the tables, APIs, concurrent programs involved in this cycle. Only technical please.
if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure
can u give guidance abt packages of plsql
How to clone the database using RMAN back
i am pursuing mca and i want to do oracle apps technical in hydrabad, plz guide me tne best institue in hydrabad those have excellent knowledge in oracle apps.
How many segment are present in Oracle Manufacturing
What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable
I am Bsc Computer Science Graduate, I have good knowledge in SQL 7.0, Can I go for Oracle APPS course please suggest me the answer
where the dff data will be stored
as a technical developer in oracle applications which type errors feced in your experience sofar
what are the API of GL,PO,AP
What is the difference between oracle media recovery and crash recovery?
