SELECT * FROM (SELECT country, sum(id) as cnt FROM mygroup GROUP BY country WITH rollup) t ORDER BY cnt;
參考網址: http://www.sqlusa.com/bestpractices2005/subtotaltotalgrandtotal/
文章標籤
全站熱搜
- 6月 07 週二 201115:43
MySQL rollup 與order by 混用
SELECT * FROM (SELECT country, sum(id) as cnt FROM mygroup GROUP BY country WITH rollup) t ORDER BY cnt;
參考網址: http://www.sqlusa.com/bestpractices2005/subtotaltotalgrandtotal/
PHP (3)