select a.sno from (select sno from t where subject='语文' and score>=60) a inner join (select sno from t where subject='数学' and score<60) b on a.sno=b.sno

相关推荐

我就是0offer糕手:北大不乱杀
点赞 评论 收藏
分享
牛客网
牛客企业服务