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

相关推荐

牛客网
牛客企业服务