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
I need a Technical evaluation between Oracle and SAP ? please do a need ful.
What is the mandatory setup in cyclecount ?
1)After defining value set we define list of values, I need to enter 1000 values with out entering manually, how will you do that? 2)what are the parameters we use in a concurrent program? 3)what is payroll processing? 4)In organization window after defining an organization and organization classification how to create a new item in the others button? 5)If there are 10 users, How to restrict the selected users not to access the forms?
What is the technical flow associated with P2P or Procure to Pay cycle like the tables, APIs, concurrent programs involved in this cycle. Only technical please.
What are different types of receipt reversals ? Explain them : oracle accounts receivable
Differentiate between writeoff and receipt writeoff. : oracle accounts receivable
What are the different tools available for hot backups in Oracle? Is it preferable to take it manually all the time or it depends on the size of the database?
What is the sql query to find the employee who has Nth maximum salary?
What is auto invoicing? : oracle accounts receivable
TILL WHAT LEVEL OF SECURITY BO SUPPORTS?
Explain prerequisites and post activities of oracle database installation
can u give guidance abt packages of plsql
What are different types of transactions in ar? : 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 ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?