下列哪个语句实现将计算机系学生各科成绩置为 0?
A.update sc set grade=0 where sc.sno=student.sno and sdept= ’cs’
B.update sc set grade =0 where sno in(select sno from student where sdept= ’cs’)
C.update grade=0 from sc where sno in(select sno from student where sdept= ’cs’)
D.update grade=0 from sc where sdept= ’cs’
查看答案
正确答案: B 答案分析:无
包含此试题的试卷:
相关的试题
Warning: mysqli_free_result() expects parameter 1 to be mysqli_result, boolean given in
/www/admin/tiku.lm158.com_80/wwwroot/wenti.php on line
166