学生成绩表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
正确答案:B
答案解析:有
微信扫一扫手机做题