可以这样：

 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