回顾数据库中的语句
Select
select * from user; 表示所有的列
select name,pwd from user; 把需要的查找的列名用逗号隔开放在select后面
select * from user where age>10; where是关键字,表示后面接查询的过滤条件
select count (work) from user; 在user表中的work列多少条,统计数值
select count () from user where sex=‘男’;
select avg(age) from user; 计算列的平均值
select count() as ‘男生总数’ from user where sex=‘男’;as表示取别名;
select sex, count() from user group by sex;
group by sex 分组 先分组,再计数
select groupname,count() from student group by groupname; 统计每个班级的人数
select groupname ,count()from student
where score>=60 group by groupname;
统计每个班的及格人数
select groupname,count() from student where score>=80 group by group by groupname order by count() desc; 统计每个班,分数大于80的人数,并且按照降序排列
select groupname ,count() from student where score>=60 group by groupname having count() >6; 统计每个班的及格人数,并且只显示及格人数大于6 的记录
2019-3-27
最新推荐文章于 2023-03-12 17:05:34 发布