syntax error with rollup clause

Question

below is the query I am writing, but for some reason it gives me a syntax error right after the word 'ROLLUP' the little red squiggle line is under the ' ( ' after rollup.

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

score 4 · Accepted Answer · answered Feb 13 '15 at 01:43

4

You need to use With Rollup in group by. Try this syntax

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

for more info check here

answered Feb 13 '15 at 01:43

Pரதீப்

91,748
19
131
172

that gave me a result! thanks. im learning sql and the book for the class i take BLOWS! – beau8008 Feb 13 '15 at 01:45
@beau8008 -You are welcome. Your syntax is valid in `MSSQL` but not in `MYSQL`. – Pரதீப் Feb 13 '15 at 01:48
yeah, the book im using doesn't tell me what sql to use, and nor did my instructor. oh well, thanks again! – beau8008 Feb 13 '15 at 02:18

syntax error with rollup clause

1 Answers1