查询出每门课都大于85 分的学生姓名

用一条SQL 语句 查询出每门课都大于85 分的学生姓名

name   course   score

Mary    语文       87

Mary     数学       75

Jeky     语文       76

Jeky     数学       90

Lisa     语文       88

Lisa     数学       100

Lisa     英语       90

sql:1

select distinct name from table_name where name not in
(select distinct name from table_name where score<=85)

sql2:

select t1.name  from 
(select name,count(name) as num from table_name where score >85 group by name )t1
 join 
(select name,count(name) as num from table_name group by name )t2  
on t1.name=t2.name and t1.num=t2.num

有别的好方法欢迎评论一起交流