my dog learned polymorphism
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

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "sum funtion based on sytem dates" Watch "sum funtion based on sytem dates" New topic

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)

Mark Spritzler

Joined: Feb 05, 2001
Posts: 17276

Just filter on your criteria in the where clause.


Perfect World Programming, LLC - iOS Apps
How to Ask Questions the Smart Way FAQ
subject: sum funtion based on sytem dates
It's not a secret anymore!