Mysql sum as last row

Is it possible to have the SUM of all numaric fields in the last of a set of rows?

As of now, I'm using a very simple query such as:

SELECT
  *,
  SUM((UNIX_TIMESTAMP(end) - UNIX_TIMESTAMP(star开发者_JS百科t))/3600)
FROM
  times

---

in SQL you cant have a column that appears in only one row, likewise, you also cant have a row that doenst contain all the columns from the other rows.. So having a row that contains something unique is not possible. You can, however, add the calculated column to all rows in the dataset or do the calculation in the calling code after the data is returned.

---

I think what you are looking for is GROUP BY WITH ROLLUP you will find details on that in the MySQL manual.