SQL复习

268 阅读1分钟

查询分数在60分(含)~90分(含)之间的学生可以使用的WHERE语句是:

 WHERE score >= 60 OR score <= 90

 WHERE score >= 60 AND score <= 90 [T]

 WHERE score IN (60, 90)

 WHERE score BETWEEN 60 AND 90 [T]

 WHERE 60 <= score <= 90

BETWEEN 和 AND 同等

x <= n <=y 和 OR 同等

n <> x 和 NOT 同等