SQL查询以获取结果集最后一行中所有列值的总和以及行总和(分组依据) [英] SQL Query to get the Sum of all column values in the last row of a resultset along with row sum (group by)

问题描述

有人可以帮助我编写查询以获取TCS和TRS吗?

Can someone please help me to write a query to obtain the TCS and TRS?

ID  Jan Feb Mar TRS
1   4   5   6   15
2   5   5   5   15
3   1   1   1   3
TCS 10  11  12  

TCS(总列总和)和TRS(总行总和)分别是新的列和行，给出了它们.

Both TCS (Total Column Sum) and TRS (Total Row Sum) are new column and row respectively which gives their.

推荐答案

您可以使用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上的实时演示.

这篇关于SQL查询以获取结果集最后一行中所有列值的总和以及行总和(分组依据)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！