select a.name from (select name,count(kecheng) kecheng from tab a group by a.ename) a , (select name,count(kecheng) kecheng80 from tab where fenshu > 80 group by name) b where a.name = b.name and a.kecheng = b.kecheng80 看我自己写的对吗?
select distinct name from t minus select distinct name from t where socre <=80
select name from tb group by name having min(chengji)>=80
select a.name
from (select name,count(kecheng) kecheng
from tab a
group by a.ename) a ,
(select name,count(kecheng) kecheng80
from tab
where fenshu > 80
group by name) b
where a.name = b.name
and a.kecheng = b.kecheng80
看我自己写的对吗?
minus
select distinct name from t where socre <=80
from tb
group by name
having min(chengji)>=80