Share this page

BETWEEN Predicate

The following table explains the operators BETWEEN and NOT BETWEEN:

Operator | Meaning |

y BETWEEN [ASYMMETRIC] x and z | x < = y and y < = z |

y NOT BETWEEN [ASYMMETRIC] x and z | not (y between x and z) |

y BETWEEN SYMMETRIC x and z | (x < = y and y < = z) or (z < = y and y < = x) |

y NOT BETWEEN SYMMETRIC x and z | not (y between symmetric x and z) |

x, y, and z are expressions, and can include subqueries.