Predicado BETWEEN

El predicado BETWEEN determina si un valor concreto está entre otros dos valores concretos.

La sintaxis del predicado es:
expression  [NOT]  BETWEEN expression-2  AND  expression-3
La expresión no debe evaluarse como un tipo booleano o de referencia.

Ejemplo: predicado BETWEEN

e.salary BETWEEN 50000 AND 60000
es equivalente a:
e.salary >= 50000  AND e.salary <= 60000
e.name NOT BETWEEN 'A' AND 'B' 
es equivalente a:
e.name < 'A'  OR e.name > 'B'

Icon that indicates the type of topic Concept topic



Timestamp icon Last updated: last_date
http://www14.software.ibm.com/webapp/wsbroker/redirect?version=cord&product=was-nd-mp&topic=cque_between
File name: cque_between.html