group by order by

[ruan_hg]

select lianxi_dw.dw as dw1,count(lianxi.id) as num from lianxi_dw left join lianxi on lianxi_dw.dw=lianxi.dw group by lianxi_dw.dw order by lianxi_dw.uid
不行！
去掉order by可以查询出数据只是顺序乱了
请帮忙写下可以排序的

[jinjazz]

select lianxi_dw.uid,lianxi_dw.dw as dw1,
count(lianxi.id) as num
from lianxi_dw left join lianxi
on lianxi_dw.dw=lianxi.dw
group by lianxi_dw.dw
order by lianxi_dw.uid

[jinjazz]

select lianxi_dw.uid,lianxi_dw.dw as dw1,
count(lianxi.id) as num
from lianxi_dw left join lianxi
on lianxi_dw.dw=lianxi.dw
group by lianxi_dw.dw ,lianxi_dw.uid
order by lianxi_dw.uid

[Yang_]

select lianxi_dw.dw as dw1,count(lianxi.id) as num from lianxi_dw left join lianxi on lianxi_dw.dw=lianxi.dw group by lianxi_dw.dw order by min(lianxi_dw.uid)

[yrwx001]

select lianxi_dw.dw as dw1,count(lianxi.id) as num from lianxi_dw left join lianxi on lianxi_dw.dw=lianxi.dw order by lianxi_dw.uid

[lwl0606]

如果一定要排序的话这样
select distinct a.*
from lianxi_dw inner join (
select lianxi_dw.dw as dw1,count(lianxi.id) as num
from lianxi_dw left join lianxi
on lianxi_dw.dw=lianxi.dw
group by lianxi_dw.dw ) a on lianxi_dw.dw=a.dw1
order by lianxi_dw.uid