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
which one is currently in used software cmpanies.
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
What is Restricted Mode of Instance Startup in Oracle?
what are the interface and api table for receipts conversion in oracle receivables? : oracle accounts receivable
What is auto invoicing? : oracle accounts receivable
difference of using cursor for loop and open,fetch,close.which one is better
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
Differentiate between earned discounts and unearned discounts? : oracle accounts receivable
Differentiate between transaction type and transaction source? : oracle accounts receivable
where the dff data will be stored
which gives Oracle R12 Financial training in delhi please give me answer its urgent?
Could you please let me know the interfaces in OM / FA??
key flexfield structure
i want to know about the javaBean.what is its purpose and how it can use in Forms.
Explain the difference between $ORACLE_HOME and $ORACLE_BASE.