Aggregates Aggregate

arg_max_null()

Finds the row with the maximum val. Calculates the arg expression at that row.

Arguments & returns

91 overloads

`arg_max_null(arg, val)`

Aggregate

Overload link	`arg`	`val`	Returns
#01	`ANY`	`ANY`	`ANY`
#02	`ANY`	`BIGINT`	`ANY`
#03	`ANY`	`BLOB`	`ANY`
#04	`ANY`	`DATE`	`ANY`
#05	`ANY`	`DOUBLE`	`ANY`
#06	`ANY`	`HUGEINT`	`ANY`
#07	`ANY`	`INTEGER`	`ANY`
#08	`ANY`	`TIMESTAMP`	`ANY`
#09	`ANY`	`TIMESTAMP WITH TIME ZONE`	`ANY`
#10	`ANY`	`VARCHAR`	`ANY`
#11	`BIGINT`	`BIGINT`	`BIGINT`
#12	`BIGINT`	`BLOB`	`BIGINT`
#13	`BIGINT`	`DATE`	`BIGINT`
#14	`BIGINT`	`DOUBLE`	`BIGINT`
#15	`BIGINT`	`HUGEINT`	`BIGINT`
#16	`BIGINT`	`INTEGER`	`BIGINT`
#17	`BIGINT`	`TIMESTAMP`	`BIGINT`
#18	`BIGINT`	`TIMESTAMP WITH TIME ZONE`	`BIGINT`
#19	`BIGINT`	`VARCHAR`	`BIGINT`
#20	`BLOB`	`BIGINT`	`BLOB`
#21	`BLOB`	`BLOB`	`BLOB`
#22	`BLOB`	`DATE`	`BLOB`
#23	`BLOB`	`DOUBLE`	`BLOB`
#24	`BLOB`	`HUGEINT`	`BLOB`
#25	`BLOB`	`INTEGER`	`BLOB`
#26	`BLOB`	`TIMESTAMP`	`BLOB`
#27	`BLOB`	`TIMESTAMP WITH TIME ZONE`	`BLOB`
#28	`BLOB`	`VARCHAR`	`BLOB`
#29	`DATE`	`BIGINT`	`DATE`
#30	`DATE`	`BLOB`	`DATE`
#31	`DATE`	`DATE`	`DATE`
#32	`DATE`	`DOUBLE`	`DATE`
#33	`DATE`	`HUGEINT`	`DATE`
#34	`DATE`	`INTEGER`	`DATE`
#35	`DATE`	`TIMESTAMP`	`DATE`
#36	`DATE`	`TIMESTAMP WITH TIME ZONE`	`DATE`
#37	`DATE`	`VARCHAR`	`DATE`
#38	`DECIMAL`	`BIGINT`	`DECIMAL`
#39	`DECIMAL`	`BLOB`	`DECIMAL`
#40	`DECIMAL`	`DATE`	`DECIMAL`
#41	`DECIMAL`	`DOUBLE`	`DECIMAL`
#42	`DECIMAL`	`HUGEINT`	`DECIMAL`
#43	`DECIMAL`	`INTEGER`	`DECIMAL`
#44	`DECIMAL`	`TIMESTAMP`	`DECIMAL`
#45	`DECIMAL`	`TIMESTAMP WITH TIME ZONE`	`DECIMAL`
#46	`DECIMAL`	`VARCHAR`	`DECIMAL`
#47	`DOUBLE`	`BIGINT`	`DOUBLE`
#48	`DOUBLE`	`BLOB`	`DOUBLE`
#49	`DOUBLE`	`DATE`	`DOUBLE`
#50	`DOUBLE`	`DOUBLE`	`DOUBLE`
#51	`DOUBLE`	`HUGEINT`	`DOUBLE`
#52	`DOUBLE`	`INTEGER`	`DOUBLE`
#53	`DOUBLE`	`TIMESTAMP`	`DOUBLE`
#54	`DOUBLE`	`TIMESTAMP WITH TIME ZONE`	`DOUBLE`
#55	`DOUBLE`	`VARCHAR`	`DOUBLE`
#56	`INTEGER`	`BIGINT`	`INTEGER`
#57	`INTEGER`	`BLOB`	`INTEGER`
#58	`INTEGER`	`DATE`	`INTEGER`
#59	`INTEGER`	`DOUBLE`	`INTEGER`
#60	`INTEGER`	`HUGEINT`	`INTEGER`
#61	`INTEGER`	`INTEGER`	`INTEGER`
#62	`INTEGER`	`TIMESTAMP`	`INTEGER`
#63	`INTEGER`	`TIMESTAMP WITH TIME ZONE`	`INTEGER`
#64	`INTEGER`	`VARCHAR`	`INTEGER`
#65	`TIMESTAMP WITH TIME ZONE`	`BIGINT`	`TIMESTAMP WITH TIME ZONE`
#66	`TIMESTAMP WITH TIME ZONE`	`BLOB`	`TIMESTAMP WITH TIME ZONE`
#67	`TIMESTAMP WITH TIME ZONE`	`DATE`	`TIMESTAMP WITH TIME ZONE`
#68	`TIMESTAMP WITH TIME ZONE`	`DOUBLE`	`TIMESTAMP WITH TIME ZONE`
#69	`TIMESTAMP WITH TIME ZONE`	`HUGEINT`	`TIMESTAMP WITH TIME ZONE`
#70	`TIMESTAMP WITH TIME ZONE`	`INTEGER`	`TIMESTAMP WITH TIME ZONE`
#71	`TIMESTAMP WITH TIME ZONE`	`TIMESTAMP`	`TIMESTAMP WITH TIME ZONE`
#72	`TIMESTAMP WITH TIME ZONE`	`TIMESTAMP WITH TIME ZONE`	`TIMESTAMP WITH TIME ZONE`
#73	`TIMESTAMP WITH TIME ZONE`	`VARCHAR`	`TIMESTAMP WITH TIME ZONE`
#74	`TIMESTAMP`	`BIGINT`	`TIMESTAMP`
#75	`TIMESTAMP`	`BLOB`	`TIMESTAMP`
#76	`TIMESTAMP`	`DATE`	`TIMESTAMP`
#77	`TIMESTAMP`	`DOUBLE`	`TIMESTAMP`
#78	`TIMESTAMP`	`HUGEINT`	`TIMESTAMP`
#79	`TIMESTAMP`	`INTEGER`	`TIMESTAMP`
#80	`TIMESTAMP`	`TIMESTAMP`	`TIMESTAMP`
#81	`TIMESTAMP`	`TIMESTAMP WITH TIME ZONE`	`TIMESTAMP`
#82	`TIMESTAMP`	`VARCHAR`	`TIMESTAMP`
#83	`VARCHAR`	`BIGINT`	`VARCHAR`
#84	`VARCHAR`	`BLOB`	`VARCHAR`
#85	`VARCHAR`	`DATE`	`VARCHAR`
#86	`VARCHAR`	`DOUBLE`	`VARCHAR`
#87	`VARCHAR`	`HUGEINT`	`VARCHAR`
#88	`VARCHAR`	`INTEGER`	`VARCHAR`
#89	`VARCHAR`	`TIMESTAMP`	`VARCHAR`
#90	`VARCHAR`	`TIMESTAMP WITH TIME ZONE`	`VARCHAR`
#91	`VARCHAR`	`VARCHAR`	`VARCHAR`

Example

SELECT arg_max_null(A, B)
FROM (VALUES
  (10, 10),
  (20, 20),
  (NULL, NULL)
) AS sample("A", "B");

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example with sample data · Run to view results.

Catalog examples

SELECT
  arg_max_null(A, B);

In other engines

BigQuery`any_value()`

SELECT ANY_VALUE(fruit HAVING MAX sold) FROM Store

In DuckDB

SELECT ARG_MAX_NULL(fruit, sold) FROM Store

SQLGlot example ↗

Available in Haybarn 1.5 DuckDB 1.5 DuckDB 1.4 DuckDB 1.3