ORDER BY 和 WITH ROLLUP 的问题

[spcmusic]

SELECT id, SUM(money) AS money FROM product GROUP BY id WITH ROLLUP ORDER BY id

报错

请问用了WITH ROLLUP，还要按字段排序怎么写？

[yumenfeiyu945]

WITH ROLLUP与order by 相互排斥，不能同时用。group by后默认就会根据该字段排序，所以不用再加order by id，如果非得排序，可以在外面加一层查询select * from (...) t ORDER BY id

[fangzhaoguo]

[Quote=引用 1 楼 的回复:]
WITH ROLLUP与order by 相互排斥，不能同时用。group by后默认就会根据该字段排序，所以不用再加order by id，如果非得排序，可以在外面加一层查询select * from (...) t ORDER BY id
[/Quote]

前提是id是primary key吧

[ACMAIN_CHM]

楼主想实现什么样的功能？建议举例说明。

[rucypli]

语法规定不行 你可以

select *
from (
SELECT id, SUM(money) AS money FROM product GROUP BY id WITH ROLLUP
)T
order by T.id