sql server2005中列的总和 [英] Sum of column in sql server2005

问题描述

嗨

这是下午raj thakur我在SQL查询中有一个总和问题。我想在sql server2005中做一个多重列的总和。我有一个像
这样的表


ID印地语Pol_Science历史数学总计

- - ----- -------- ------ ----- ----

1 67.00 67.00 89.00 89.00？

2 89.00 89.00 88.00 67.00？

3 55.00 65.00 69.00 90.00？

4 56.00 78.00 98.00 67.00？



我想在每一行的总数中加总乘数列。

喜欢这样



ID - 印地语 - Pol_Science - 历史---数学---总计

- - ----- -------- ------ ----- ----

1 - 67.00 --- 67.00 --- 89.00 --- 89.00 --- 312.00

2 - 89.00 --- 9.00 - - 88.00 --- 67.00 --- 333.00

3 - 55.00 --- 65.00 --- 69.00 --- 90.00 --- 279.00

4 - 56.00 --- 78.00 --- 98.00 --- 67.00 --- 299.00





提前谢谢

hi
this is hem raj thakur I have a sum problem in a sql query. I want to do Sum of a multipal column in a sql server2005.I have a table like

ID Hindi Pol_Science History Math Total
-- ----- -------- ------ ----- ----
1 67.00 67.00 89.00 89.00 ?
2 89.00 89.00 88.00 67.00 ?
3 55.00 65.00 69.00 90.00 ?
4 56.00 78.00 98.00 67.00 ?

I wanna "sum" of multipal "column" in "total" in per single row.
like this

ID -- Hindi -- Pol_Science -- History --- Math --- Total
-- -- ----- -------- ------ ----- ----
1 -- 67.00 ---67.00 --- 89.00--- 89.00 --- 312.00
2 -- 89.00 --- 9.00 --- 88.00 --- 67.00 --- 333.00
3 -- 55.00 --- 65.00 --- 69.00 --- 90.00 --- 279.00
4 -- 56.00 --- 78.00 --- 98.00 --- 67.00 --- 299.00


thanks in advance

推荐答案

select a,b,c,d,(a+b+c+d) as total from table_name

用你的列名替换a，b，c，d ..

replace a,b,c,d with your column name..

这篇关于sql server2005中列的总和的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！