22,210
社区成员
发帖
与我相关
我的任务
分享
INSERT INTO 表2
( AA ,
NO1 ,
NO2
)
SELECT AA ,
SUM([NO]) AS NO1 ,
SUM(CASE WHEN BB = N'中国' THEN [NO]
ELSE 0
END)
FROM 表1
GROUP BY AA;
INSERT INTO 表2
SELECT AA, NO1 = SUM(NO), NO2=SUM(CASE WHEN BB='中国' THEN NO END)
FROM 表1
GROUP BY AA