22,209
社区成员
发帖
与我相关
我的任务
分享
Select school,SUM(shouldPay) AS shouldPay from #T GROUP BY school
IF OBJECT_ID('t') IS NOT NULL DROP TABLE t
GO
CREATE TABLE t(
[no] int primary key,
school NVARCHAR(10),
grade NVARCHAR(10),
stuName NVARCHAR(10),
shouldPay INT
)
GO
SET NOCOUNT ON
INSERT INTO t
SELECT 1,'龙山','第1学期','zs1',2000
UNION ALL SELECT 2,'龙山','第1学期','zs2',2000
UNION ALL SELECT 3,'龙山','第1学期','zs3',2000
UNION ALL SELECT 4,'龙山','第1学期','zs4',2000
UNION ALL SELECT 5,'龙山','第2学期','zs5',3000
UNION ALL SELECT 6,'龙山','第2学期','zs6',3000
UNION ALL SELECT 7,'龙山','第2学期','zs7',3000
UNION ALL SELECT 8,'龙山','第2学期','zs8',3000
UNION ALL SELECT 9,'龙山','第2学期','zs9',3000
GO
--按学校和学期汇总
SELECT
school AS [学校]
,grade [学期]
,SUM(shouldPay) AS [应交学费]
FROM t
GROUP BY school,grade
/*
学校 学期 应交学费
---------- ---------- -----------
龙山 第1学期 8000
龙山 第2学期 15000
*/
--只按学校汇总,不管学期(所有学期)
SELECT
school AS [学校]
,SUM(shouldPay) AS [应交学费]
FROM t
GROUP BY school
/*
学校 应交学费
---------- -----------
龙山 23000
*/