sql语句

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 的记录

左连接右连接都是外连接