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?
- 7 Answers
- 11280 Views
- TCS, I also Faced
- E-Mail Answers
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
How would you determine what sessions are connected and what resources they are waiting for?
Explain how to close periods in ar. : oracle accounts receivable
if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure
Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable
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
I need a Technical evaluation between Oracle and SAP ? please do a need ful.
How to clone the database using RMAN back
Difference between negative and positive adjustments : oracle accounts receivable
I am Bsc Computer Science Graduate, I have good knowledge in SQL 7.0, Can I go for Oracle APPS course please suggest me the answer
what are the API of GL,PO,AP
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
can u pls share responsibilities for production how to environment in odi?and how to generate report ?
What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable
What is the difference between oracle media recovery and crash recovery?
What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?
