查询所有课程成绩小于60分的同学的学号、姓名;

select S_ID,Sname from Student where S_ID not in (select S.S_ID from Student AS S,SC where S.S_ID=SC.S_ID and score>60);

posted @ 2020-11-17 15:25  加菲啊  阅读(3278)  评论(0编辑  收藏  举报