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
How would you go about increasing the buffer cache hit ratio?
while creating requisitions i am unable to see the list of organisation can anyone help me out ?
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.
What is supporting issues GL AP and AR?
Differentiate between transaction type and transaction source? : oracle accounts receivable
What is an Oracle database Full Backup?
can u pls share responsibilities for production how to environment in odi?and how to generate report ?
can u give guidance abt packages of plsql
please send me oracle pl/sql exp resume. and also faqs...
What is the meaning of "Modulus" and "Alignment" in a datafile. Data file might be from any database. Data file is created through unloading data from a table. So, while loading this data into my table, I need to use these keywords. Could any one can help me regarding this?
what are the interface and api table for receipts conversion in oracle receivables? : oracle accounts receivable
default triggers available for reports
HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?
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
how to write customizations in po