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

相关推荐

11-07 21:45
已编辑
福建省建阳第一中学 golang
点赞 评论 收藏
分享
牛客网
牛客企业服务