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 payment_id,payment_date from care_billing_payment
order by payment_id desc limit 10;
this query give latest 10 rows;
Is This Answer Correct ? | 6 Yes | 7 No |
Post New Answer View All Answers
hi iam kavya, i completed Oracle11i(finance module), i do not know how to face the interview questions please adivese me
difference of using cursor for loop and open,fetch,close.which one is better
what are basic modules required to implement oracle application in any oraganisation?
i am pursuing mca and i want to do oracle apps technical in hydrabad, plz guide me tne best institue in hydrabad those have excellent knowledge in oracle apps.
Explain the process of recievables in oracle financials. : oracle accounts receivable
what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?
which gives Oracle R12 Financial training in delhi please give me answer its urgent?
Explain accounting for invoice in advance and arrears. : oracle accounts receivable
What is the difference between oracle media recovery and crash recovery?
PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE
Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha
What is the difference between conversions and interfaces? : oracle accounts receivable
what is difference between inner join & nested query or subqueries
IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?
Differentiate between earned discounts and unearned discounts? : oracle accounts receivable