Julian Hyde created CALCITE-5283: ------------------------------------ Summary: Add ARG_MIN, ARG_MAX (aka MIN_BY, MAX_BY) aggregate functions Key: CALCITE-5283 URL: https://issues.apache.org/jira/browse/CALCITE-5283 Project: Calcite Issue Type: Bug Reporter: Julian Hyde
Add ARG_MIN, ARG_MAX (aka MIN_BY, MAX_BY) aggregate functions. For example, the following query prints the name of the lowest paid employee in each department: {code} SELECT deptno, ARG_MIN(sal, ename) FROM emp GROUP BY deptno; +------------+------------+ | deptno | _c1 | +------------+------------+ | 10 | MILLER | | 20 | SMITH | | 30 | JAMES | +------------+------------+ {code} If multiple employees have the same salary, arbitrarily chooses one to return. See [Yandex description of ARG_MIN|https://cloud.yandex.com/en/docs/datalens/function-ref/ARG_MIN]. Also implemented in Kusto, Alibaba MaxCompute, Clickhouse, DuckDB. -- This message was sent by Atlassian Jira (v8.20.10#820010)