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
点赞 评论

相关推荐

牛客网
牛客企业服务