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


Please Help Members By Posting Answers For Below Questions

How would you go about increasing the buffer cache hit ratio?

1957


while creating requisitions i am unable to see the list of organisation can anyone help me out ?

1707


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.

3337


What is supporting issues GL AP and AR?

1991


Differentiate between transaction type and transaction source? : oracle accounts receivable

680






What is an Oracle database Full Backup?

634


can u pls share responsibilities for production how to environment in odi?and how to generate report ?

1910


can u give guidance abt packages of plsql

1646


please send me oracle pl/sql exp resume. and also faqs...

2039


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?

1598


what are the interface and api table for receipts conversion in oracle receivables? : oracle accounts receivable

644


default triggers available for reports

1759


HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?

1591


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

1768


how to write customizations in po

1200