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
8. Supporting AP, AR and GL?
Explain about party and customer in ar : oracle accounts receivable
What is Tax Categories?
What is autocashrule set? : oracle accounts receivable
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.
What is the mandatory setup in cyclecount ?
HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..
WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?
Difference between transaction type and transaction sources. : oracle accounts receivable
what is semphore explian it?
how to write customizations in po
key flexfield structure
What do you mean by hz_ in customer tables? : oracle accounts receivable
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
PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE