select nvl(sno,'合计') sno,sum(score) score from sc group by rollup(sno); 转载于:https://www.cnblogs.com/feng666666/p/5898949.html