在线急求!

[taito]

表A
id cname province
1 张 广东
2 李 广东
3 王 湖北
4 郑 湖南
5 付 湖南
6 吴 广东

求结果(排序)
province counts
广东 3
湖南 2
湖北 1

[子陌红尘]

select province,count(*) as counts from 表 group by province order by counts

[子陌红尘]

select province,count(*) as counts from 表 group by province order by counts desc

[quanyi]

select province,count(*) as counts from 表 group by province order by counts desc

[xiaoku]

楼上已经解决。。。
又没我份了！

[simonhehe]

select province,count(*) as counts from 表 group by province order by counts desc