RE: colum totals

2005-09-16 Thread Tony Leake
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]

RE: colum totals

2005-09-16 Thread Mark Leith
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

colum totals

2005-09-16 Thread Tony Leake
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