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
y d
you probably want to add in a where clause
where MONTH(date) = 4
to limit the rows to all days in april, for example.
hth.
-ravi.
-Original Message-
From: Graham Nichols [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 01, 2001 11:23 AM
To: [EMAIL PROTECTED]
Subject: Newbie group/cou
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 stumbling around with it all day without success.
Many th
