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'

指示主题类型的图标 概念主题



时间戳记图标 最近一次更新时间: last_date
http://www14.software.ibm.com/webapp/wsbroker/redirect?version=cord&product=was-nd-mp&topic=cque_between
文件名:cque_between.html