您可以使用GROUP BY和WITH ROLLUP，如下所示:

You can use GROUP BY and WITH ROLLUP, like this:

SELECT
    id
,   SUM(jan) as jan
,   SUM(feb) as feb
,   SUM(mar) as mar
,   SUM(jan+feb+mar) as TRS
FROM test
GROUP BY id WITH ROLLUP

sqlfiddle上的实时演示.