Sum of column in sql server2005

See more:

SQL-Server-2005

SQL-Server

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