问题遇到的现象和发生背景
我写成下面这种形式对了没,
你手写的代码中有一些语法错误。改了的代码:
DELETE FROM sc
WHERE sno IN
(SELECT sno FROM sc
WHERE grade = (SELECT MIN(grade) FROM sc
WHERE cno IN (SELECT cno FROM course WHERE cname='VB'))
AND cno IN (SELECT cno FROM course WHERE cname='VB'))