SELECT week, sum(tips) FROM mytable GROUP BY week;
[EMAIL PROTECTED] wrote:
I have a table of daily information (tips, # of deliveries, etc.).
Does anyone know of an easy way using SQL to extract all weekly sums of a field?
Like:
week 1: sum of tips for that week week 2: sum of tips for that week week 3: sum of tips for that week week 4: sum of tips for that week week 5: sum of tips for that week
I can do them one week per query (obviously) but would like one query that will spit them all out, one after the other.
--
Veysel Harun Sahin [EMAIL PROTECTED]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
