学生成绩表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 and score <=60
正确答案:C,D
答案解析:有
微信扫一扫手机做题