现有表学生信息(xsxx),内有字段省市(ss)，怎样用sql语句统计各省的人数？要求输出字段为ss，人数！急急急~

---

select ss,count(*) from xsxx group by ss

输出的第一个字州郑段册腊颂是局让ss,第二个字段是各个省市的学生人数

---

select count(*) from [xsxx] where [ss]='省'

返回字段则渗斗ss的值是指孙磨定省的记录条数喊拆

---

select count(ss) as ss
from xsxx
group by ss

这样就可以了

---

select ss,count(*) as sum_person from xsxx group by ss

---