select name, sum(case when score > 80 then 0 else 1 end) as s
group by name having s = 0;

select name, min(score) as s from table group by name having s > 80;

【 在 useCASE 的大作中提到: 】
: 姓名    课程    成绩
: 张三    英语    90
: 张三    数学    76
: ...................
--
修改:qlogic FROM 119.139.197.*
FROM 119.139.197.*