aspose file tools*
The moose likes Oracle/OAS and the fly likes sum funtion based on sytem dates Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "sum funtion based on sytem dates" Watch "sum funtion based on sytem dates" New topic
Author

sum funtion based on sytem dates

arjun rampal
Ranch Hand

Joined: Jul 08, 2005
Posts: 125
Hi I have a column "TOTAL" which is adding numbers in it rows.I am using SUM Function for that.
Problem-I dont want the sum of all rows .I want sum of only last 5 days before system date.
for example if today is 29 october as per my computer.I want summantion of 23+25+26+27+28+29(24 not included as it is sunday).

it would be greate if solution would be specific

is that possible if yes how?
present query SUM(TOTAL)

REGARDS
Mark Spritzler
ranger
Sheriff

Joined: Feb 05, 2001
Posts: 17259
    
    6

Just filter on your criteria in the where clause.


Mark


Perfect World Programming, LLC - Two Laptop Bag - Tube Organizer
How to Ask Questions the Smart Way FAQ
 
wood burning stoves
 
subject: sum funtion based on sytem dates