河南成教 / 数据库应用1
正确率:100%
2、学生成绩表grade中有字段score(float),现在要把所有在55分至60之间的分数提高5分,以下sql语句正确的是 (分数:3 分)
A. Update grade set score=score 5
B. Update grade set score=score 5 where score>=55 or score <=60
C. Update grade set score=score 5 where score between 55 and 60
D. Update grade set score=score 5 where score >=55 and score <=60
A. Update grade set score=score 5
B. Update grade set score=score 5 where score>=55 or score <=60
C. Update grade set score=score 5 where score between 55 and 60
D. Update grade set score=score 5 where score >=55 and score <=60
参考答案:
佳题速递: