cube 中 grouping 的使用.sql

初学者

SELECT CASE WHEN(GROUPING(CLASS_NAME)=1 )THEN '汇总数据' 
            ELSE ISNULL(CLASS_NAME,'无班级名')
            END,
        AVG(STU_SCORE)
FROM STUDENT INNER JOIN CLASS ON STUDENT.CLASS_ID=CLASS.CLASS_ID
GROUP BY CLASS_NAME WITH CUBE