[freetds] Query - Sum(data) by Date?
Shaun Craig
s.craig at andronics.com
Thu Nov 10 10:47:47 EST 2005
How do i go about this, i have a single table 'Flow' which holds values
for a particular object for a date, ie
'Object' 'Level' 'Date/Time'
Object1 2.0 Nov 09 2005 10:02AM
Object1 3.3 Nov 09 2005 11:32AM
Object1 1.2 Nov 09 2005 13:12PM
etc........
Object1 3.4 Nov 10 2005 04:12AM
Object1 0.1 Nov 10 2005 11:23PM
etc...
I want a query which will sum(level) for each date, so result will look
like the following
'Object' 'Total Level for Date' 'Date'
Object1 6.5 Nov 09 2005
Object1 3.5 Nov 10 2005
Any ideas, had a look on the web but you need to sign up to stuff to see
solutions, not an option.
Thanks,
Shaun.
More information about the FreeTDS
mailing list