Home > Archive > MySQL Databases > July 2005 > Calculated rows









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Calculated rows
neeper

2005-07-31, 8:24 pm

I have a table of transactions and I am confused as to generate a sql
statement to how sum the transactions by day/date.

I need it outputted something like this:

Date # of Transactions Gross Value Total
April 14 10 $140 $240
Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com