group by如何排序

[ysr1980]

分组语句group by默认为升序，如何成降序

[张海霖]

select * from table1 order by id desc

[ysr1980]

我指的是
select a,sum(b) from table1
group by a
按A分组之后如何降序

[lilu207]

默认升序
降序用 order by id desc
如果要order by 多个字段则：
order by id desc,name asc
只有紧跟desc和asc前面的才按这个排序

[lilu207]

select a,sum(b) from table1
group by a
order by a desc

[ysr1980]

我试了，不行

[lsxaa]

select a,sum(b) from table1
group by a order by 排序字段

[lilu207]

select a,sum(b) from table1
group by a,b
order by a desc
你group by里必须要select 里显示的所有字段

[ysr1980]

谢谢各位，我弄错了