Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › adding up data and numbering table rows?

adding up data and numbering table rows?

Thread began 10/21/2009 7:28 pm by dean248377 | Last modified 4/04/2014 10:13 pm by dean248377 | 6091 views | 12 replies

10/22/2009 9:09 amJason ByrnesWebAssist

SOJO Web has question 1 covered.

For question 2, use the SUM() function for the number column and GROUP BY the date column:

SELECT SUM(numberColumn) AS numCount FROM tblName GROUP BY dateColumn

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.