select id,area,stu_type,sum(score) score
from students
group by rollup(id,area,stu_type)
order by id,area,stu_type;
本文共 171 字，大约阅读时间需要 1 分钟。
select id,area,stu_type,sum(score) score
from students
group by rollup(id,area,stu_type)
order by id,area,stu_type;
转载于:https://www.cnblogs.com/fanweisheng/p/11118903.html