代码参考:
use Demo go select Name,ExamNode ,Course,avg(Num) from SumDemo group by Name,ExamNode,Course with cube order by Name desc,ExamNode desc,Course desc go
代码参考:
use Demo go select Name,ExamNode ,Course,avg(Num) from SumDemo group by Name,ExamNode,Course with cube order by Name desc,ExamNode desc,Course desc go