题目内容:
查询同时选修课程号为C1和C5课程的学生的学员,正确的命令是( )。A)SELECT学号FROM score sc WHERE课程号=‘Cl’AND学号IN
(SELECT学号FROM score sc WHERE课程号=‘C5’)
B)SELECT学号FROM score sc WHERE课程号=‘Cl’AND学号=
(SELECT学号FROM score sc WHERE课程号='C5')
C)SELECT学号FROM score sc WHERE课程号='Cl'AND课程号='C5'
D)SELECT学号FORM score sc WHERE课程号='C1'OR 'C5'
参考答案:
答案解析: