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
- 11340 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
How to move the data from one flatfile to multiple staging tables?give me some examples? for example in po interface one flat file is there and multiple staging tables are there how can move it?please give me answer for this question?
CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
What is the use of lockboxes? Steps for lock box : oracle accounts receivable
What is the use of lockboxes? : oracle accounts receivable
what ASIS BUSINESS PROCESS IN ORACLE FINANCE
Are These Dff's Flexible?
can u give guidance abt packages of plsql
Could you please let me know the interfaces in OM / FA??
Explain how to account for bank charges deducted from amount received against an invoice. : oracle accounts receivable
How would you determine who has added a row to a table?
as a technical developer in oracle applications which type errors feced in your experience sofar
how to write customizations in po
How would you go about increasing the buffer cache hit ratio?
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?
