You can just use function sum to get what you want.
On Jan 16, 2008 6:23 AM, Imran <[EMAIL PROTECTED]> wrote:
> Hi:
>
>
>
> I have a table that I need help to summarize the data. I need to be able
> to
> create one row of data for custno + prodno + period + weekno combination
> summarized by Invt
select count(*), substring(timeofclick,1,7) from MTracking where
mallarea=1001 group by 2;
On 5/3/06, Randy Paries <[EMAIL PROTECTED]> wrote:
Hello,
Not sure if i can do this.
I have a table with a datetime column
I would like to do group by a day of the month.
if i do something like
sel
try:
group by substring(timeofclick,1,10)
-Original Message-
From: Randy Paries [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 03, 2006 11:25 AM
To: mysql@lists.mysql.com
Subject: Help with this query. How to do a group by on a datetime just
the month/day/year
Hello,
Not sure if i ca
