SELECT n0703 ,n0704=SUM(n0704) FROM TB GROUP BY n0703
IF NOT OBJECT_ID('AA') IS NULL DROP TABLE AA GO CREATE TABLE AA([N0703] NVARCHAR(2),[N0704] DECIMAL(18,1)) Insert AA SELECT N'C0',238 UNION ALL SELECT N'A0',26 UNION ALL SELECT N'A0',17 UNION ALL SELECT N'A0',296 UNION ALL SELECT N'A0',299 UNION ALL SELECT N'A0',79 UNION ALL SELECT N'A0',20 UNION ALL SELECT N'A0',283.8 UNION ALL SELECT N'A0',7 Go SELECT N0703,N0704=SUM(N0704) FROM AA GROUP BY N0703 /* N0703 N0704 ----- ---------------------------------------- A0 1027.8 C0 238.0(所影响的行数为 2 行) */
SELECT n0703 ,n0704=SUM(n0704) FROM TB GROUP BY n0703
SELECT n0703 ,n0704=SUM(n0704) FROM TB GROUP BY n0703
SELECT n0703 ,n0704=SUM(n0704) FROM TB GROUP BY n0703
SELECT n0703 ,n0704=SUM(n0704) FROM TB GROUP BY n0703
GO
CREATE TABLE AA([N0703] NVARCHAR(2),[N0704] DECIMAL(18,1))
Insert AA
SELECT N'C0',238 UNION ALL
SELECT N'A0',26 UNION ALL
SELECT N'A0',17 UNION ALL
SELECT N'A0',296 UNION ALL
SELECT N'A0',299 UNION ALL
SELECT N'A0',79 UNION ALL
SELECT N'A0',20 UNION ALL
SELECT N'A0',283.8 UNION ALL
SELECT N'A0',7
Go
SELECT N0703,N0704=SUM(N0704) FROM AA GROUP BY N0703
/*
N0703 N0704
----- ----------------------------------------
A0 1027.8
C0 238.0(所影响的行数为 2 行)
*/
SELECT n0703 ,n0704=SUM(n0704) FROM TB GROUP BY n0703