Simpson [EMAIL PROTECTED]
Subject: Re: Do I need to use GROUP BY to do this?
To: Grant Giddens [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Date: Wednesday, June 18, 2008, 11:02 AM
I happen to have worked on a similar query
Hi,
nbsp; I have a table where I keep sales transactions, so I'm trying to do a
query that will count the number of transactions per day.
My test data looks like:
--
-- Table structure for table `sales_activity`
--
CREATE TABLE `sales_activity` (
nbsp; `sales_id` int(11) NOT NULL
Re: Do I need to use GROUP BY to do this?
yes
Grant Giddens schrieb:
Hi,
nbsp; I have a table where I keep sales transactions, so I'm trying to do a
query that will count the number of transactions per day.
My test data looks like:
What type of query do I need to get that information
I happen to have worked on a similar query this morning, so it's in my
mind :)
SELECT SUBSTRING(sales_date,1,10), COUNT(sales_id)
FROM sales_activity
WHERE sales_type = 1
GROUP BY SUBSTRING(sales_date,1,10);
should do the trick.
On Tue, 2008-06-17 at 18:21 -0700, Grant Giddens wrote:
Hi,