select 名字 from 成绩单 where 名字 not in (select 名字 from 成绩单 where 成绩 <60) ; select p from 表 where p in (select P from 表 group by P having count(*)=2 ) and p in (select P from 表 where tag in ('A','B') group by P having count(*)=2 );

相关推荐

牛客网
牛客网在线编程
牛客网题解
牛客企业服务