On Tue, 1 May 2001, Graham Nichols wrote:
> I have a table which contains a date column and an order_number column. I
> need to formulate a query syntax to return the total number of orders for
> each day in a given month (if any). Can someone help me with the syntax
> please as I've been stumbli
hi.
your table looks something like this:
table1
-
date(date)
order_number int(6)
...i wasn't sure if "order_number" is referring to a "order" table
somewhere...
if there are multiple rows for each day, and you want to add up
"order_number" for each day, use:
select
DAYOFMONT