[freetds] Query - Sum(data) by Date?
ZIGLIO, Frediano, VF-IT
Frediano.Ziglio at vodafone.com
Thu Nov 10 11:10:34 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.
select Object, sum(Level) as [Total Level for Date], Date From
table_name group by Object, Date
Well... you group by date which is a (small)datetime, if (small)datetime
contains time you have to strip time part using come convert/cast like
select Object, sum(Level) as [Total Level for Date],
convert(smalldatetime, convert(varchar(20), Date, 112), 112) as Date
>From table_name group by Object, convert(smalldatetime,
convert(varchar(20), Date, 112), 112)
freddy77
More information about the FreeTDS
mailing list