單項(xiàng)選擇題

學(xué)生成績(jī)表grade中有字段score(float),現(xiàn)在要把所有在55至60分之間的分?jǐn)?shù)提高5分,以下SQL語(yǔ)句正確的是()。

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

微信掃碼免費(fèi)搜題