求一SQL语句。能实现按count(?)排序 在线等

[爱我的人请呼吸]

　　
有一语句

select a,b,count(b) as x from [T] where a='0'
group by a,b
having count(b)>=1
order by b

现在的要求不能按b排序。要按count(b)的结果进行排序

尝试了一下order by x不行。呵呵。

请各位兄弟指点一下怎么能实现按count(b)进行排序

先谢了

[liangCK]

ORDER BY count(b)

[playwarcraft]

order by x 不行？？？？

[sdhdy]

select * from (select a,b,count(b) as x from [T] where a='0' 
group by a,b 
having count(b)>=1) c order by x 

[sdhdy]

select a,b,count(b) as x from [T] where a='0' 
group by a,b 
having count(b)>=1 order by x

[lgx0914]

?

select a,b,count(b) as x from [T] where a='0' 
group by a,b 
having count(b)>=1 
order by count(b) 

[爱我的人请呼吸]

茅塞顿开

偶试了order by x不行居然就没去再尝试一下order by count(b)

罪过。。。


[Quote=引用 2 楼 playwarcraft 的回复:]
order by x 不行？？？？
[/Quote]

回这位大哥。我这里用order by x会提示“至少有一个参数没有指定值"

但是用order by count(b)就可以


再次感谢楼上几位大哥

给分好为难。平均给分吧。再次感谢

[ks_reny]

select a,b,count(b) as x from [T] where a='0' 
group by a,b 
having count(b)>=1 
order by count(b) 

來晚了.

[ly24860865]

select a,b,count(b) as x from [T] where a='0'
group by a,b
having count(b)>=1
order by count(b)

[gafinal]

我开看看

[y150988451]

学习 学习