KATER__MIN

Family: Aggregations

Syntax

1
KATER__MIN(field)

Arguments

Returns

A value of the field’s own type. The field menu writes the @format of the field it reads beside it, or @format number(2) where that field has none and can have decimals.

Usage notes

• On a date, it is the earliest. On text, it is the first in the warehouse’s sort order.
• Empty values are left out.

Example

This Sandbox query reads the sample shop’s orders. The table shows the rows that Kater gave.

1
SELECT
2
  orders.region AS "Region",
3
  KATER__MIN(orders.order_date) AS "First Order"
4
FROM kater_dataset.orders AS orders
5
GROUP BY
6
  orders.region
7
ORDER BY
8
  1

Compiles to

The call compiles to the same SQL on DuckDB and on Snowflake.

1
MIN(orders.order_date)

See also

• Measures
• Other functions in Aggregations: KATER__SUM, KATER__AVG, KATER__MAX, KATER__COUNT, KATER__COUNT_DISTINCT, KATER__COUNT_TRUE, KATER__COUNT_FALSE, KATER__LIST