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 / rajesh
select * from(select * from table_name order by date_column
desc) where rowid<=10
Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?
What is auto invoicing? : oracle accounts receivable
What is the importance of batch source set up in ar? : oracle accounts receivable
Differentiate between writeoff and receipt writeoff. : oracle accounts receivable
default triggers available for reports
TILL WHAT LEVEL OF SECURITY BO SUPPORTS?
What is Restricted Mode of Instance Startup in Oracle?
WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?
What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable
How to clone the database using RMAN back
Why more redos are generated when the oracle database is in begin backup mode?
what is the link between suppliers and banks in ap module in oracle apps? And also query?
Differentiate between transaction type and transaction source? : oracle accounts receivable
Explain the use of table functions.
HOW TO SPOT AHIERARCHY?