mySQL常用语句

1、查询所有科目分数大于80的姓名
SELECT name FROM grade GROUP BY name HAVING MIN(score) > 80;
SELECT DISTINCT name FROM grade WHERE name NOT IN(SELECT DISTINCT name FROM grade WHERE score <=80);
2、查询结果的前一百条
select * from tbl limit 100;
3、查询至少选修两门课程的学生学号
select 学号, count(课程号) as 选修课程数目
from score
group by 学号
having count(课程号)>=2;
4、查询两门以上不及格课程的同学的学号及其平均成绩
select 学号, avg(成绩) as 平均成绩
from score
where 成绩 <60
group by 学号
having count(课程号)>=2;