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.
--
Trevor Smith | tr****@haligonian.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw