Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

which one is currently in used software cmpanies.

2164


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

2283


What is Restricted Mode of Instance Startup in Oracle?

1202


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

1134


What is auto invoicing? : oracle accounts receivable

1167


difference of using cursor for loop and open,fetch,close.which one is better

1810


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

2527


Differentiate between earned discounts and unearned discounts? : oracle accounts receivable

1174


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

1119


where the dff data will be stored

2452


which gives Oracle R12 Financial training in delhi please give me answer its urgent?

2501


Could you please let me know the interfaces in OM / FA??

2276


key flexfield structure

2183


i want to know about the javaBean.what is its purpose and how it can use in Forms.

2467


Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

7685