17,090
社区成员
发帖
与我相关
我的任务
分享
-- 试试这个
select name
from t
group by name
having count(*) = sum(case when fenshu > 80 then 1 else 0 end)
select distinct s1.name from student s1 where s1.name not in (s2.name from student s2 where s2.分数<=80);
select name
from student
where fenshu>'80'
group by name
having count(1)=2