学生成绩表grade中有字段score(float),现在要把所有在55~60分之间的分数提高5分,以下SQL语句正确的是( )。
选项:
A:UPDATE grade SET score=score+5 WHERE score In 55.. 60
B:UPDATE grade SET score=score+5 WHERE score>=55 And score<=60
C:UPDATE grade SET score=score+5 WHERE score Between 55 Or 60
D:UPDATE grade SET score=score+5 WHERE score<=55 And score>=60
发布时间:2024-04-13 13:12:34