当前位置:百科知识 > 工学8

问题描述:

[多选] 学生成绩表grade中有字段score(float),现在要把所有在55分至60之间的分数提高5分,以下sql语句正确的是()
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 anscore <=60
参考答案:查看
答案解析:
☆收藏

随机题目