SQL查询出每门课都大于80 分的学生姓名
Course表如下：
查询出每门课都大于80 分的学生姓名有两种方法。
1.select distinct name from Course where name not in (select distinct name from Course where score<=80)
2.select name from Course group by name having min(score)>80
Course表如下：
查询出每门课都大于80 分的学生姓名有两种方法。
1.select distinct name from Course where name not in (select distinct name from Course where score<=80)
2.select name from Course group by name having min(score)>80