Can you really have the sum of the all numaric fields within the last of some rows?
By now, I am using a simple query for example:
SELECT *, SUM((UNIX_TIMESTAMP(end) - UNIX_TIMESTAMP(start))/3600) FROM times
in SQL you cannot possess a column that seems in just one row, likewise, additionally you cant possess a row that doenst contain all of the posts in the other rows.. So getting a row that consists of something unique isn't feasible. You are able to, however, add the calculated column to any or all rows within the dataset or perform the calculation within the calling code following the information is came back.
I believe what you're searching for is
GROUP BY WITH ROLLUP you'll find particulars on that within the MySQL manual.