单选题

学生成绩表grade中有字段score(float),现在要把所有在55至60分之间的分数提高5分,以下SQL语句正确的是()。

AUpdate grade set score=score+5 where score in 55..60

BUpdate grade set score=score+5 where score >=55 AND score <=60

CUpdate grade set score=score+5 where score between 55 or 60

DUpdate grade set score=score+5 where score <=55 and score >=60

正确答案

来源:www.examk.com

答案解析