mysql - rollup 子句的语法错误

Question

下面是我正在写的查询，但由于某种原因，它在“ROLLUP”一词之后给我一个语法错误，红色的小波浪线在汇总后的“(”下面。

SELECT building, room_number, time_slot_id, COUNT(*)
FROM class1
GROUP BY ROLLUP (building, room_number, time_slot_id)

Answer 1

你需要在group by中使用With Rollup。试试这个语法

SELECT building, room_number, time_slot_id, COUNT(*)
FROM class1
GROUP BY building, room_number, time_slot_id WITH ROLLUP 

了解更多信息 check here