题目内容
(请给出正确答案)
[主观题]
如果想限制sc(sno,cno,grade)表中每人最多选三门课,如何用断言表示?sc(sno,cno,grade)表示选修(学号,课程号,成绩)
A、Create assertion asse1 check(3>=all(select count(*) from sc group by sno))
B、Create assertion asse1 check(3>=any(select count(*) from sc group by sno))
C、Create assertion asse1 check(3>=some(select count(*) from sc group by sno))
D、Create assertion asse1 check(3>= select count(*) from sc group by sno)
提问人:网友aqjazz
发布时间:2022-01-07