一道sql题引发的关于where、having、group by、order by 的思考
上原题:
我的语句:
CREATE TRIGGER t on SC FOR INSERT AS DELETE FROM SC WHERE EXISTS(SELECT * FROM inserted WHERE SC.sno = inserted.sno and SC.cno = inserted.cno)
AND sno IN (SELECT sno FROM SC WHERE g...
原创
2019-04-22 17:44:00 ·
161 阅读 ·
0 评论