有人幫忙解析一下這段代碼嗎
SELECT student.sno,sname FROM student
WHERE NOT EXISTS(SELECT * FROM course WHERE EXISTS(SELECT * FROM sc WHERE student.sno=sc.sno and sc.cno=course.cno and cname='軟件工程'));
SELECT student.sno,sname FROM student
WHERE NOT EXISTS(SELECT * FROM course WHERE EXISTS(SELECT * FROM sc WHERE student.sno=sc.sno and sc.cno=course.cno and cname='軟件工程'));
2019-05-22
舉報