sql按字段值进行统计

用group by

如有个student表里有性别sex来统计

select sex,count(*) from student group by sex;