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 / laxman
SELECT * FROM emp group by emp_date asc limit 10;
| Is This Answer Correct ? | 2 Yes | 6 No |
Post New Answer View All Answers
Hi, IN oracle apps HRMS, if the employee changes his department, and when a conconurrent program is run for calulating the pay, The latest Dept id is not diaplayed, howeber the previous deptid is considered. Please can someone tell me where is the program going wrong, which side?
what are the interface and api table for receipts conversion in oracle receivables? : oracle accounts receivable
What is Tax Categories?
A scenario for amount correction & how to use amount correction functionality in AP invoices
How would you go about increasing the buffer cache hit ratio?
Explain accounting for invoice in advance and arrears. : oracle accounts receivable
Explain the use of table functions.
What is the mandatory setup in cyclecount ?
Can we modify approve purchase order?if yes what is navigation?
What is the use of lockboxes? : oracle accounts receivable
Are These Dff's Flexible?
default triggers available for reports
What is an Oracle database Partial Backup?
What is the difference between recovery and restoring of the oracle database?
HOW TO SPOT AHIERARCHY?