22,209
社区成员
发帖
与我相关
我的任务
分享
;WITH CTE AS(
SELECT 班级,姓名,SUM(成绩)[总成绩]
,ROW_NUMBER()OVER(PARTITION BY 班级 ORDER BY SUM(成绩) DESC)RN
FROM TB
GROUP BY 班级,姓名
)
SELECT * FROM CTE WHERE RN<=3
好强,真速度!;WITH CTE AS(
SELECT 班级,姓名,SUM(成绩)[总成绩]
,ROW_NUMBER()OVER(PARTITION BY 班级 ORDER BY SUM(成绩) DESC)RN
FROM TB
GROUP BY 班级,姓名
)
SELECT * FROM CTE WHERE RN<=3
-- 表结构可以给下么?
-- 成绩表中有哪些字段?是否还会有关联表,比如班级编号也在成绩表中?