可以这样:
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