On this page
Kater SQL Functions Conditions
KATER__IS_BETWEEN
True where the field is between the low and the high end, both ends included.
Family: Conditions
Syntax
KATER__IS_BETWEEN(field, low, high)Arguments
| Argument | Description |
|---|---|
field | The number, date or timestamp to test. |
low | The low end. It is included. Or write one range parameter a reader supplies, for both ends. |
high | The high end. It is included. Left out when a range parameter gives both. |
Returns
TRUE or FALSE. It is NULL where the field is empty, so a filter leaves that row out.
Usage notes
- A range parameter, such as a date range in the filter bar, gives both ends. Write it once, in place of low and high.
Example
This Sandbox query reads the sample shop’s orders. The table shows the rows that Kater gave.
SELECT orders.quantity AS "Quantity", EVAL(orders.count_distinct__order_id) AS "Orders"FROM kater_dataset.orders AS ordersWHERE KATER__IS_BETWEEN(orders.quantity, 2, 4)GROUP BY orders.quantityORDER BY 1| Quantity | Orders |
|---|---|
| 2 | 601 |
| 3 | 594 |
| 4 | 595 |
Compiles to
The call compiles to the same SQL on DuckDB and on Snowflake.
orders.quantity BETWEEN 2 AND 4See also
- Filters and parameters
- Other functions in Conditions:
KATER__IS_EQUAL_TO,KATER__IS_NOT_EQUAL_TO,KATER__IS_GREATER_THAN,KATER__IS_AT_LEAST,KATER__IS_LESS_THAN,KATER__IS_AT_MOST,KATER__IS_ONE_OF,KATER__IS_NOT_ONE_OF,KATER__TEXT_CONTAINS,KATER__TEXT_DOES_NOT_CONTAIN,KATER__IS_NULL,KATER__IS_NOT_NULL