安装APP,随时看
文档分类
当前位置:首页 > 数据库原理试卷答案
(3)CTEATE VIEW SDB AS
SELECT SNO, SN FROM S, SC, C
WHERE S.SNO=SC.SNO AND SC.CNO=C.CNO AND C.CN=’DB’;(4分)
(4)UPDATE SC SET G=1.1*G WHERE CNO IN
(SELECT CNO FROM C
WHERE CN=’英语’);(4分)
共分享92篇相关文档