BETWEEN 谓词
BETWEEN 谓词确定一个给定值是否位于其他两个给定值之间。
谓词的语法是:
expression [NOT] BETWEEN expression-2 AND expression-3表达式不能求值为布尔值或引用类型。
示例:BETWEEN 谓词
e.salary BETWEEN 50000 AND 60000
等同于:
e.salary >= 50000 AND e.salary <= 60000
e.name NOT BETWEEN 'A' AND 'B'
等同于:
e.name < 'A' OR e.name > 'B'