若要使所有学科80分以上的成绩都增加5%, 80至60分的成绩都增加10%,应如何更新数据库( )。 A.UPDATE SC SET GRADE=GRADE*1.05 WHERE SC.GRADE>=80 UPDATE SC SET GRADE=GRADE* 1.10 WHERE SC.GRADE>=60 AND SC.GRADE <=80 B.UPDATE SC SET GRADE=GRADE* 1.10 WHERE SC.GRADE>=60 AND SC.GRADE<=80 UPDATE SC SET GRADE=GRADE* 1.05 WHERE SC.GRADE>=80 C.UPDATE SC SET GRADE=GRADE* 1.05 WIRE SC.GRADE>=80 AND SET GRADE =GRADE* 1.10 WHARE SC.GRADE>=60 D.UPDATE SC SET GRADE=GRADE* 1.10 WHERE SC.GRADE>=60 AND SC.GRADE <=80 AND SET GRADE=GRADE* 1.05 WHERE SC.GRADE>=80
A、UPDATE SC SET GRADE=GRADE*1.05 WHERE SC.GRADE>=80 UPDATE SC SET GRADE=GRADE* 1.10 WHERE SC.GRADE>=60 AND SC.GRADE <=80
B、UPDATE SC SET GRADE=GRADE* 1.10 WHERE S
C、GRADE>=60 AND SC.GRADE<=80 UPDATE SC SET GRADE=GRADE* 1.05 WHERE SC.GRADE>=80 C.UPDATE SC SET GRADE=GRADE* 1.05 WIRE SC.GRADE>=80 AND SET GRADE =GRADE* 1.10 WHARE SC.GRADE>=60
D、UPDATE SC SET GRADE=GRADE* 1.10 WHERE SC.GRADE>=60 AND SC.GRADE <=80 AND SET GRADE=GRADE* 1.05 WHERE SC.GRADE>=80
查看答案
正确答案
试题解析
Update 语句用于修改表中的数据,语法:UPDATE 表名称 SET 列名称 = 新值 WHERE 列名称 = 某值,根据语法,表名称应该为SC,GRADE=GRADE*1.05,条件为SC.GRADE>=80,后面的60到80分的同理。