select name, SUM(count) from stats group by name;
-Original Message-
From: news [mailto:[EMAIL PROTECTED]]On Behalf Of Max Clark
Sent: Wednesday, December 11, 2002 4:05 PM
To: [EMAIL PROTECTED]
Subject: Newbie - group and tally help
Hi-
I am trying to write a sql query that will select
Hi-
I am trying to write a sql query that will select, group and tally records
returned.
select name, count from stats order by name;
foo2
foo4
foo6
foo15
foo210
foo315
I would like the output to be like this:
foo12
foo130
How do I accomplish this in mysql?
Th