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
- 11841 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / ranjan satapathy
Your query: to get latest 10 dates from the table
select date_column , *
from table
where date_column between sysdate and (sysdate-10)
will show the latest date upto 10 last day
| Is This Answer Correct ? | 2 Yes | 8 No |
Post New Answer View All Answers
WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?
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 difference between inner join & nested query or subqueries
where the dff data will be stored
Can we modify approve purchase order?if yes what is navigation?
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
while creating requisitions i am unable to see the list of organisation can anyone help me out ?
Is there any link between pr form(purchse requisition)and po form(purchase order)
What is db_recovery_file_dest in oracle? When do you need to set this value?
Differentiate between transaction type and transaction source? : oracle accounts receivable
PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE
types of receipts and detail desription about recipts and tables effected by receipts?
i am pursuing mca and i want to do oracle apps technical in hydrabad, plz guide me tne best institue in hydrabad those have excellent knowledge in oracle apps.
Tell me about entire study of finacle software as soon as possible? give me the idea about questions which coulb be asked in interview of pnb it officers?
What is chargeback invoice? How do we create it? : oracle accounts receivable
