cube的Demo

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