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?
Answer Posted / syam kumar
SELECT * FROM emp order by emp_date asc limit 10;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
we have 10 concurrent programs under one request group out of 10 ccps all users submitting only 9 programs from srs window remaining one ccp for specific user how can it possible send me answer asap.
What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable
CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?
Differentiate between transaction type and transaction source? : oracle accounts receivable
What is auto invoicing? : oracle accounts receivable
how can we add a field to the oracle standard forms through Form Persanlization or custom.pll
Explain about party and customer in ar : oracle accounts receivable
What is the difference between recovery and restoring of the oracle database?
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
i am working with OC 4.5 i have numbers in table in 10 row with some null values please tell me how to find total? Thanks
Explain prerequisites and post activities of oracle database installation
difference of using cursor for loop and open,fetch,close.which one is better
How would you go about increasing the buffer cache hit ratio?
How would you determine who has added a row to a table?