各位大侠，小弟再请教个数据查询统计方面的问题，望多多指教！

表：students

姓名：name
性别：sex
生日：birthday
祖藉：addrs

 例：

 select count(name) as n_nums,addrs from students group by addrs order by count(name) desc

     显示如下：

                n_nums                          addrs

                    13                           山东
                    11                           海南
                     8                           河南
 

[ 本帖最后由 sunfishy 于 2010-10-13 14:38 编辑 ]