Returns whether or not a given value is within a range of values.
Determine whether AMOUNT_SOLD is between 1000 and 2000.
between(Sales_Acme.Sales.AMOUNT_SOLD, 1000, 2000)
between(double expr value, double expr min, double expr max)
- value : value to test
- min : lower limit of test range
- max : upper limit of test range
between determines whether the value resulting from evaluating value fits within the range defined by evaluating the min and max expressions. The range is inclusive of the boundary values.