对表增加属性使用什么语句?
A.ADD
B.ALTER
C.INSERT
D.CREATE
- · 有3位网友选择 C,占比37.5%
- · 有3位网友选择 B,占比37.5%
- · 有1位网友选择 D,占比12.5%
- · 有1位网友选择 A,占比12.5%
A.ADD
B.ALTER
C.INSERT
D.CREATE
A、πS#,C#(SC)÷πC#(σTNAME='LIU'(SC)) SELECT DISTINCT S# FROM SC AS X WHERE NOT EXISTS (SELECT * FROM C WHERE TNAME=’LIU’ AND NOT EXISTS (SELECT * FROM SC AS Y WHERE Y.S#=X.S# AND Y.C#=C.C#));
B、πS#,C#(SC)÷πC#(σTNAME='LIU'(C)) SELECT DISTINCT S# FROM SC AS X WHERE NOT EXISTS (SELECT * FROM C WHERE TNAME=’LIU’ AND NOT EXISTS (SELECT * FROM SC AS Y WHERE Y.S#=X.S# AND Y.C#=C.C#));
C、πS#,C#(SC)÷πC#(σTNAME='LIU'(C)) SELECT DISTINCT S# FROM SC AS X WHERE NOT EXISTS (SELECT * FROM C WHERE TNAME=’LIU’ AND EXISTS (SELECT * FROM SC AS Y WHERE Y.S#=X.S# AND Y.C#=C.C#));
D、πS#,C#(SC)÷πC#(σTNAME='LIU'(C)) SELECT DISTINCT S# FROM SC WHERE NOT EXISTS (SELECT * FROM C WHERE TNAME=’LIU’ AND EXISTS (SELECT * FROM SC AS Y WHERE Y.S#=X.S# AND Y.C#=C.C#));
为了保护您的账号安全,请在“简答题”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!