On Fri, 2005-09-16 at 14:02 +0100, Mark Leith wrote:
> http://dev.mysql.com/doc/mysql/en/group-by-modifiers.html
>
perfect, thank you.
tony
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
t; Sent: 16 September 2005 13:19
> To: mysql@lists.mysql.com
> Subject: colum totals
>
> Hi,
>
> I'm sure I read somewhere about a new function that would
> give the totals of all columns, ie if i have 2 cols,
> numberOfOrders valueOfOrders for a range of dates i can get
> so
Hi,
I'm sure I read somewhere about a new function that would give the
totals of all columns, ie if i have 2 cols, numberOfOrders valueOfOrders
for a range of dates i can get something like the following
Date numberOfOrdersvalueOfOrders
01-09 4 20.00
02-09 6