sql不会 求大神帮忙2....

图片说明

可以这样:

 select * from t_Score where fName not in 
            (select distinct fName from t_Score where fGrade < 60)

如果对您有帮助,请采纳答案好吗,谢谢!

select * from t_score a where not exists (select 1 from t_score b where b.fname=a.fname and b.fgrade<60) ;

select * from t_score where fGrade>60;

思路:按姓名分组,找出该姓名的人成绩中的最低分,如果最低分都大于60,那么其他成绩必定合格
select * from t_score group by fName having min(fGrade)>60