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 / 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


Please Help Members By Posting Answers For Below Questions

8. Supporting AP, AR and GL?

2311


Explain about party and customer in ar : oracle accounts receivable

1211


What is Tax Categories?

2112


What is autocashrule set? : oracle accounts receivable

1404


How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.

2193


What is the mandatory setup in cyclecount ?

2753


HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..

2512


WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?

2113


Difference between transaction type and transaction sources. : oracle accounts receivable

1032


what is semphore explian it?

2815


how to write customizations in po

1618


key flexfield structure

2179


What do you mean by hz_ in customer tables? : oracle accounts receivable

1221


1.In a table Gender is a column in that male and female are the two data.In a single statement i have to modify all male to female and all female to male vice versa. 2.In a single query i need the count of male data,count of female and total count

17641


PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE

2223