每次遇到面试题 都会有这样的SQL语句
然而网上给的答案一般是
select s_id, s_name, s_age, s_sex from total group by s_id having count(c_id) <科目数 ;
当有人重修or补考时也加入这个表中,就会出现一门没修,而某一门重修2次,导致查询结果显示这个人是“学全”了。
为了排除这种情况
select s_id, s_name, s_age, s_sex from total
where s_id in
(SELECT b.s_id FROM
(SELECT s_id,c_id FROM student,course<