操作系统与网络 2019-4-3

1.MySQL

1.1 统计男生的个数

• 1.首先显示的是student.ssex，这个属性在表student中，条件是ssex=‘男’；

select count(ssex) from student where student.ssex = '男';

• 2.统计女生的个数

select count(ssex) from student where student.ssex = '女';

• 3.将男生人数和女生人数都显示出来

select count(ssex) from student where student.ssex = '男'
union all
select count(ssex) from student where student.ssex = '女';

1.2 分组统计

• 1.只显示每个组的第一个，按男女进行分组

select * from student group by student.ssex;

• 2.显示所有性别的个数

select count(ssex) from student group by student.ssex;

• 3.在显示时多显示一列性别的列

select count(ssex), ssex from student group by student.ssex;

• 4.显示时添加一个ssex个数大于0的条件

select count(ssex), ssex from student group by ssex having count(ssex) > 0;

• 5.在显示列时将列重命名

select count(ssex)aa, ssex from student group by ssex having count(ssex) > 0