Re: Sum by date
From: Roel Toledo <SPAMGUARDroeltoledo_at_yahoo.com>
Date: Tue, 16 Oct 2001 07:07:39 GMT
Message-ID: <%0Ry7.141456$W8.3270643_at_bgtnsc04-news.ops.worldnet.att.net>
Date: Tue, 16 Oct 2001 07:07:39 GMT
Message-ID: <%0Ry7.141456$W8.3270643_at_bgtnsc04-news.ops.worldnet.att.net>
>select trunc(date_column), count(*)
>from table
>group by trunc(date_column)
It should be sum(num_column) instead of count(*) Received on Tue Oct 16 2001 - 09:07:39 CEST