如何将GROUP BY 的结果按照降序排列？

[cyo]

如何将GROUP BY 的结果按照降序排列？

[yoki]

order by col1,col2... desc

[pbsql]

GROUP BY ...
OREDR BY ...desc
写成一样的顺序就行了

[pengdali]

select xxx,sum(yy) ee from tablename GROUP BY xxx OREDR BY sum(yy) desc

[qyqn]

group by ..
order by .. desc

[dafu71]

group by col1,col2,... order by col1,col2,... desc

[alexmeng]

ORDER BY 栏位名称 DESC

[redcola]

加上ORDER BY
默认为升序，加DESC就是降序了
例如，依照价格高低来显示所有书籍的信息，输入以下SQL语句：
SELECT * FROM book ORDER BY price DESC

group by 某某
order by 某某某 desc
一样的排