110,538
社区成员
发帖
与我相关
我的任务
分享
DECLARE @tab TABLE
(
pproid INT,
pbasedig INT,
pbasewaterdig INT,
pbasesteel INT
)
INSERT INTO @tab
SELECT 1, 100, 120 ,100 UNION ALL
SELECT 2, 100, 120, 100 UNION ALL
SELECT 3, 100, 120, 100 UNION ALL
SELECT 3, 100, 120, 100
SELECT pproid,SUM(pbasedig) AS pbasedig ,SUM(pbasewaterdig) AS pbasewaterdig,SUM(pbasesteel) AS pbasesteel FROM @tab WHERE pproid=3 GROUP BY pproid
/*
(所影响的行数为 4 行)
pproid pbasedig pbasewaterdig pbasesteel
----------- ----------- ------------- -----------
3 200 240 200
(所影响的行数为 1 行)
*/
DECLARE @tab TABLE
(
pproid INT,
pbasedig INT,
pbasewaterdig INT,
pbasesteel INT
)
INSERT INTO @tab
SELECT 1, 100, 120 ,100 UNION ALL
SELECT 2, 100, 120, 100 UNION ALL
SELECT 3, 100, 120, 100 UNION ALL
SELECT 3, 100, 120, 100
SELECT pproid,SUM(pbasedig) AS pbasedig ,SUM(pbasewaterdig) AS pbasewaterdig,SUM(pbasesteel) AS pbasesteel FROM @tab WHERE pproid=3 GROUP BY pproid
/*
(所影响的行数为 4 行)
pproid pbasedig pbasewaterdig pbasesteel
----------- ----------- ------------- -----------
3 200 240 200
(所影响的行数为 1 行)
*/
select pproid,sum(pbasedig),sum(pbasewaterdig),sum(pbasesteel) from xxx where pproid=3 group by pproid