用一条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
有别的好方法欢迎评论一起交流