22,209
社区成员
发帖
与我相关
我的任务
分享
;WITH tab1(id,a,b,c)AS(
select 1,1,2,3 union all
select 1,2,3,5
)
SELECT id ,
SUM(a + b + c) AS 和
FROM tab1
GROUP BY id
SELECT *, a+b+c AS 单行和 FROM table1
SELECT SUM(a+b+c) AS 总和 FROM table1