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
- 11582 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
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 different types of receipt reversals ? Explain them : 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
3. Steps in UAT?
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 ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?
How would you determine what sessions are connected and what resources they are waiting for?
if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure
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.
please send me oracle pl/sql exp resume. and also faqs...
CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?
What is the difference between conversions and interfaces? : oracle accounts receivable
while creating requisitions i am unable to see the list of organisation can anyone help me out ?
Explain how to close periods in ar. : oracle accounts receivable
key flexfield structure
