GROUP BY GROUPING SETS ROLLUP()报错

Question

运行sql 这端代码报错
SELECT 
 c_grade,c_class,c_subject,SUM(c_score)
FROM tb_student_score
GROUP BY GROUPING SETS ((c_grade,c_class,c_subject),ROLLUP(c_grade))

 

报错信息

SELECT 
 c_grade,c_class,c_subject,SUM(c_score)
FROM tb_student_score
GROUP BY GROUPING SETS ((c_grade,c_class,c_subject),ROLLUP(c_grade))
> 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SETS ((c_grade,c_class,c_subject),ROLLUP(c_grade))' at line 4
> 时间: 0s

 

有大佬知道是为啥吗

Answer 1

Mysql语法不支持grouping