# arg_max — DuckDB 1.5.5

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

- Reference: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/
- JSON: /products/haybarn/functions/api/v1/duckdb-1.5.5/functions/arg_max.json
- Snapshot ID: duckdb-1.5.5
- Engine: duckdb v1.5.5
- Source ID: d8cdaa33fd
- Binary SHA-256: 8463eb26527b278109cfddffc4606e1019ebefcfe2eac75efc53c76ed8f282d5
- Captured: 2026-09-05T18:37:40.699Z
- Source: https://github.com/duckdb/duckdb/releases/tag/v1.5.5
- Loaded extensions: autocomplete, core_functions, icu, json, parquet, shell

## Interpretation

- Choose a snapshot matching the target engine and build. The default is captured from the published Haybarn WASM package used by the browser playground. Historical native snapshots are also available.
- Availability is an observation in the recorded build and extension profile, not a guarantee of support in every installation or in WASM.
- Types and descriptions are declarations from duckdb_functions(). Binding can specialize result types. Null means not supplied by the catalog; do not invent defaults, optionality, argument mode, or table output columns.
- Raw parameter arrays preserve catalog order for scalar/aggregate/macro functions. Raw table arguments are alphabetical. Use callingConvention for engine-confirmed positional order and named arguments; null modes are unrecorded. Named does not mean optional. Macro defaults and special named variadic behavior are not supplied by duckdb_functions().
- Catalog examples are source material and may require data or extensions. runnableExamples contains separately verified SQL for the pinned WASM package; sample-data adaptations and guide examples are labeled separately.
- Guide annotations and recipes are separate editorial content. The browser runner always uses Haybarn WASM 1.5.5-rc3, independently of the documentation snapshot.
- All URLs beginning with / are relative to the origin hosting this document. Exports require no JavaScript, cookies, API key, or browser engine.

## Overloads

### overload-7a13cd64de4d1d57

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: ANY, val: ANY) → ANY
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-7a13cd64de4d1d57

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | ANY | not recorded |
| val | ANY | not recorded |

Declared return type: ANY. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-8af6a66932f47f6e

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: ANY, val: BIGINT) → ANY
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-8af6a66932f47f6e

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | ANY | not recorded |
| val | BIGINT | not recorded |

Declared return type: ANY. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-f518d6c0f0a1da08

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: ANY, val: BLOB) → ANY
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-f518d6c0f0a1da08

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | ANY | not recorded |
| val | BLOB | not recorded |

Declared return type: ANY. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-0905ae7763faacb1

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: ANY, val: DATE) → ANY
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-0905ae7763faacb1

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | ANY | not recorded |
| val | DATE | not recorded |

Declared return type: ANY. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-31e60c1fc95ec249

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: ANY, val: DOUBLE) → ANY
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-31e60c1fc95ec249

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | ANY | not recorded |
| val | DOUBLE | not recorded |

Declared return type: ANY. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-e71eb89d2847860c

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: ANY, val: HUGEINT) → ANY
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-e71eb89d2847860c

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | ANY | not recorded |
| val | HUGEINT | not recorded |

Declared return type: ANY. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-d25d2cdedcef39cf

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: ANY, val: INTEGER) → ANY
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-d25d2cdedcef39cf

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | ANY | not recorded |
| val | INTEGER | not recorded |

Declared return type: ANY. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-bc66245450296d53

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: ANY, val: TIMESTAMP) → ANY
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-bc66245450296d53

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | ANY | not recorded |
| val | TIMESTAMP | not recorded |

Declared return type: ANY. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-6994f06e5c8b45c0

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: ANY, val: TIMESTAMP WITH TIME ZONE) → ANY
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-6994f06e5c8b45c0

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | ANY | not recorded |
| val | TIMESTAMP WITH TIME ZONE | not recorded |

Declared return type: ANY. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-54cbab4aff0b9161

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: ANY, val: VARCHAR) → ANY
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-54cbab4aff0b9161

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | ANY | not recorded |
| val | VARCHAR | not recorded |

Declared return type: ANY. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-6fa435197cb4b0f4

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: BIGINT, val: BIGINT) → BIGINT
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-6fa435197cb4b0f4

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | BIGINT | not recorded |
| val | BIGINT | not recorded |

Declared return type: BIGINT. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-66d6bd89c95f59bf

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: BIGINT, val: BLOB) → BIGINT
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-66d6bd89c95f59bf

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | BIGINT | not recorded |
| val | BLOB | not recorded |

Declared return type: BIGINT. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-25e7a8e7afeb663a

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: BIGINT, val: DATE) → BIGINT
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-25e7a8e7afeb663a

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | BIGINT | not recorded |
| val | DATE | not recorded |

Declared return type: BIGINT. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-cb380c4575ec6e9c

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: BIGINT, val: DOUBLE) → BIGINT
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-cb380c4575ec6e9c

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | BIGINT | not recorded |
| val | DOUBLE | not recorded |

Declared return type: BIGINT. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-cc7da9ef3380a4ba

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: BIGINT, val: HUGEINT) → BIGINT
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-cc7da9ef3380a4ba

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | BIGINT | not recorded |
| val | HUGEINT | not recorded |

Declared return type: BIGINT. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-9a46d6fc0c9acef0

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: BIGINT, val: INTEGER) → BIGINT
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-9a46d6fc0c9acef0

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | BIGINT | not recorded |
| val | INTEGER | not recorded |

Declared return type: BIGINT. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-3c9e05990da128e2

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: BIGINT, val: TIMESTAMP) → BIGINT
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-3c9e05990da128e2

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | BIGINT | not recorded |
| val | TIMESTAMP | not recorded |

Declared return type: BIGINT. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-ab8b29bf1676924c

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: BIGINT, val: TIMESTAMP WITH TIME ZONE) → BIGINT
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-ab8b29bf1676924c

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | BIGINT | not recorded |
| val | TIMESTAMP WITH TIME ZONE | not recorded |

Declared return type: BIGINT. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-b8c942ff8eef9891

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: BIGINT, val: VARCHAR) → BIGINT
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-b8c942ff8eef9891

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | BIGINT | not recorded |
| val | VARCHAR | not recorded |

Declared return type: BIGINT. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-4222d3d4fba43f31

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: BLOB, val: BIGINT) → BLOB
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-4222d3d4fba43f31

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | BLOB | not recorded |
| val | BIGINT | not recorded |

Declared return type: BLOB. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-b5121a4af955dd9b

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: BLOB, val: BLOB) → BLOB
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-b5121a4af955dd9b

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | BLOB | not recorded |
| val | BLOB | not recorded |

Declared return type: BLOB. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-e798732a7d1542a8

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: BLOB, val: DATE) → BLOB
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-e798732a7d1542a8

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | BLOB | not recorded |
| val | DATE | not recorded |

Declared return type: BLOB. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-33107e088955a655

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: BLOB, val: DOUBLE) → BLOB
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-33107e088955a655

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | BLOB | not recorded |
| val | DOUBLE | not recorded |

Declared return type: BLOB. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-d3c866a9f23a2f5f

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: BLOB, val: HUGEINT) → BLOB
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-d3c866a9f23a2f5f

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | BLOB | not recorded |
| val | HUGEINT | not recorded |

Declared return type: BLOB. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-1224567de6e1693b

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: BLOB, val: INTEGER) → BLOB
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-1224567de6e1693b

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | BLOB | not recorded |
| val | INTEGER | not recorded |

Declared return type: BLOB. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-1f9240e4fa20d261

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: BLOB, val: TIMESTAMP) → BLOB
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-1f9240e4fa20d261

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | BLOB | not recorded |
| val | TIMESTAMP | not recorded |

Declared return type: BLOB. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-599996b4117e1054

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: BLOB, val: TIMESTAMP WITH TIME ZONE) → BLOB
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-599996b4117e1054

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | BLOB | not recorded |
| val | TIMESTAMP WITH TIME ZONE | not recorded |

Declared return type: BLOB. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-be3fcd3bcc4cc5a2

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: BLOB, val: VARCHAR) → BLOB
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-be3fcd3bcc4cc5a2

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | BLOB | not recorded |
| val | VARCHAR | not recorded |

Declared return type: BLOB. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-1face098a76423ff

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: DATE, val: BIGINT) → DATE
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-1face098a76423ff

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | DATE | not recorded |
| val | BIGINT | not recorded |

Declared return type: DATE. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-1c6a251a20a76979

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: DATE, val: BLOB) → DATE
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-1c6a251a20a76979

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | DATE | not recorded |
| val | BLOB | not recorded |

Declared return type: DATE. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-9259159219cd4a86

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: DATE, val: DATE) → DATE
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-9259159219cd4a86

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | DATE | not recorded |
| val | DATE | not recorded |

Declared return type: DATE. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-f70426ec2654db32

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: DATE, val: DOUBLE) → DATE
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-f70426ec2654db32

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | DATE | not recorded |
| val | DOUBLE | not recorded |

Declared return type: DATE. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-af6969ef3f056ede

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: DATE, val: HUGEINT) → DATE
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-af6969ef3f056ede

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | DATE | not recorded |
| val | HUGEINT | not recorded |

Declared return type: DATE. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-261969f50c62f7cd

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: DATE, val: INTEGER) → DATE
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-261969f50c62f7cd

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | DATE | not recorded |
| val | INTEGER | not recorded |

Declared return type: DATE. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-dddc1244f06d77d5

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: DATE, val: TIMESTAMP) → DATE
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-dddc1244f06d77d5

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | DATE | not recorded |
| val | TIMESTAMP | not recorded |

Declared return type: DATE. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-65edfd4a1eed42f1

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: DATE, val: TIMESTAMP WITH TIME ZONE) → DATE
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-65edfd4a1eed42f1

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | DATE | not recorded |
| val | TIMESTAMP WITH TIME ZONE | not recorded |

Declared return type: DATE. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-f76bb49496e91ea2

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: DATE, val: VARCHAR) → DATE
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-f76bb49496e91ea2

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | DATE | not recorded |
| val | VARCHAR | not recorded |

Declared return type: DATE. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-929f7fc31b9b3e3e

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: DECIMAL, val: BIGINT) → DECIMAL
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-929f7fc31b9b3e3e

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | DECIMAL | not recorded |
| val | BIGINT | not recorded |

Declared return type: DECIMAL. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-93d5f0a5d7131e15

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: DECIMAL, val: BLOB) → DECIMAL
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-93d5f0a5d7131e15

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | DECIMAL | not recorded |
| val | BLOB | not recorded |

Declared return type: DECIMAL. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-f84f20e2cbe9c8fb

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: DECIMAL, val: DATE) → DECIMAL
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-f84f20e2cbe9c8fb

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | DECIMAL | not recorded |
| val | DATE | not recorded |

Declared return type: DECIMAL. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-dcb95e327c7efc08

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: DECIMAL, val: DOUBLE) → DECIMAL
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-dcb95e327c7efc08

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | DECIMAL | not recorded |
| val | DOUBLE | not recorded |

Declared return type: DECIMAL. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-4da1ff2df1a8692f

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: DECIMAL, val: HUGEINT) → DECIMAL
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-4da1ff2df1a8692f

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | DECIMAL | not recorded |
| val | HUGEINT | not recorded |

Declared return type: DECIMAL. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-cbbd29631206f083

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: DECIMAL, val: INTEGER) → DECIMAL
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-cbbd29631206f083

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | DECIMAL | not recorded |
| val | INTEGER | not recorded |

Declared return type: DECIMAL. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-4f5bf1d783009bf0

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: DECIMAL, val: TIMESTAMP) → DECIMAL
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-4f5bf1d783009bf0

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | DECIMAL | not recorded |
| val | TIMESTAMP | not recorded |

Declared return type: DECIMAL. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-66668253642d62d6

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: DECIMAL, val: TIMESTAMP WITH TIME ZONE) → DECIMAL
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-66668253642d62d6

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | DECIMAL | not recorded |
| val | TIMESTAMP WITH TIME ZONE | not recorded |

Declared return type: DECIMAL. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-b645c32db667fd70

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: DECIMAL, val: VARCHAR) → DECIMAL
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-b645c32db667fd70

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | DECIMAL | not recorded |
| val | VARCHAR | not recorded |

Declared return type: DECIMAL. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-e1c36a72e245187a

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: DOUBLE, val: BIGINT) → DOUBLE
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-e1c36a72e245187a

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | DOUBLE | not recorded |
| val | BIGINT | not recorded |

Declared return type: DOUBLE. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-a47acddb2c378efc

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: DOUBLE, val: BLOB) → DOUBLE
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-a47acddb2c378efc

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | DOUBLE | not recorded |
| val | BLOB | not recorded |

Declared return type: DOUBLE. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-2ed8cdee645c88a4

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: DOUBLE, val: DATE) → DOUBLE
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-2ed8cdee645c88a4

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | DOUBLE | not recorded |
| val | DATE | not recorded |

Declared return type: DOUBLE. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-e7f25b0da1a20041

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: DOUBLE, val: DOUBLE) → DOUBLE
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-e7f25b0da1a20041

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | DOUBLE | not recorded |
| val | DOUBLE | not recorded |

Declared return type: DOUBLE. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-77cdb387565cc05d

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: DOUBLE, val: HUGEINT) → DOUBLE
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-77cdb387565cc05d

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | DOUBLE | not recorded |
| val | HUGEINT | not recorded |

Declared return type: DOUBLE. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-abbb813e8a0e47bb

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: DOUBLE, val: INTEGER) → DOUBLE
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-abbb813e8a0e47bb

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | DOUBLE | not recorded |
| val | INTEGER | not recorded |

Declared return type: DOUBLE. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-1a7487471b7a2295

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: DOUBLE, val: TIMESTAMP) → DOUBLE
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-1a7487471b7a2295

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | DOUBLE | not recorded |
| val | TIMESTAMP | not recorded |

Declared return type: DOUBLE. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-cd3046965902c896

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: DOUBLE, val: TIMESTAMP WITH TIME ZONE) → DOUBLE
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-cd3046965902c896

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | DOUBLE | not recorded |
| val | TIMESTAMP WITH TIME ZONE | not recorded |

Declared return type: DOUBLE. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-f6e0ab4cd9e7c5ea

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: DOUBLE, val: VARCHAR) → DOUBLE
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-f6e0ab4cd9e7c5ea

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | DOUBLE | not recorded |
| val | VARCHAR | not recorded |

Declared return type: DOUBLE. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-45c3722bfa95a48b

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: INTEGER, val: BIGINT) → INTEGER
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-45c3722bfa95a48b

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | INTEGER | not recorded |
| val | BIGINT | not recorded |

Declared return type: INTEGER. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-07cf10a23be1aff6

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: INTEGER, val: BLOB) → INTEGER
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-07cf10a23be1aff6

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | INTEGER | not recorded |
| val | BLOB | not recorded |

Declared return type: INTEGER. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-62acc52261dbcce0

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: INTEGER, val: DATE) → INTEGER
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-62acc52261dbcce0

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | INTEGER | not recorded |
| val | DATE | not recorded |

Declared return type: INTEGER. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-dfd6e7cf3731ed04

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: INTEGER, val: DOUBLE) → INTEGER
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-dfd6e7cf3731ed04

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | INTEGER | not recorded |
| val | DOUBLE | not recorded |

Declared return type: INTEGER. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-338f56f075a0471b

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: INTEGER, val: HUGEINT) → INTEGER
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-338f56f075a0471b

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | INTEGER | not recorded |
| val | HUGEINT | not recorded |

Declared return type: INTEGER. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-b63676408ef94995

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: INTEGER, val: INTEGER) → INTEGER
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-b63676408ef94995

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | INTEGER | not recorded |
| val | INTEGER | not recorded |

Declared return type: INTEGER. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-df62ac2716b062a8

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: INTEGER, val: TIMESTAMP) → INTEGER
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-df62ac2716b062a8

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | INTEGER | not recorded |
| val | TIMESTAMP | not recorded |

Declared return type: INTEGER. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-7f9162fba25dabfa

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: INTEGER, val: TIMESTAMP WITH TIME ZONE) → INTEGER
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-7f9162fba25dabfa

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | INTEGER | not recorded |
| val | TIMESTAMP WITH TIME ZONE | not recorded |

Declared return type: INTEGER. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-71db361695a57d5a

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: INTEGER, val: VARCHAR) → INTEGER
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-71db361695a57d5a

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | INTEGER | not recorded |
| val | VARCHAR | not recorded |

Declared return type: INTEGER. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-d3c6c1e11dc66648

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: TIMESTAMP WITH TIME ZONE, val: BIGINT) → TIMESTAMP WITH TIME ZONE
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-d3c6c1e11dc66648

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | TIMESTAMP WITH TIME ZONE | not recorded |
| val | BIGINT | not recorded |

Declared return type: TIMESTAMP WITH TIME ZONE. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-b48fcfbfabccd4ec

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: TIMESTAMP WITH TIME ZONE, val: BLOB) → TIMESTAMP WITH TIME ZONE
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-b48fcfbfabccd4ec

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | TIMESTAMP WITH TIME ZONE | not recorded |
| val | BLOB | not recorded |

Declared return type: TIMESTAMP WITH TIME ZONE. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-3120d4a422e14167

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: TIMESTAMP WITH TIME ZONE, val: DATE) → TIMESTAMP WITH TIME ZONE
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-3120d4a422e14167

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | TIMESTAMP WITH TIME ZONE | not recorded |
| val | DATE | not recorded |

Declared return type: TIMESTAMP WITH TIME ZONE. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-9dd3801de9955c95

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: TIMESTAMP WITH TIME ZONE, val: DOUBLE) → TIMESTAMP WITH TIME ZONE
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-9dd3801de9955c95

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | TIMESTAMP WITH TIME ZONE | not recorded |
| val | DOUBLE | not recorded |

Declared return type: TIMESTAMP WITH TIME ZONE. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-919c4490fe047353

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: TIMESTAMP WITH TIME ZONE, val: HUGEINT) → TIMESTAMP WITH TIME ZONE
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-919c4490fe047353

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | TIMESTAMP WITH TIME ZONE | not recorded |
| val | HUGEINT | not recorded |

Declared return type: TIMESTAMP WITH TIME ZONE. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-548d16ded4ba47aa

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: TIMESTAMP WITH TIME ZONE, val: INTEGER) → TIMESTAMP WITH TIME ZONE
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-548d16ded4ba47aa

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | TIMESTAMP WITH TIME ZONE | not recorded |
| val | INTEGER | not recorded |

Declared return type: TIMESTAMP WITH TIME ZONE. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-3901c78894ab394d

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: TIMESTAMP WITH TIME ZONE, val: TIMESTAMP) → TIMESTAMP WITH TIME ZONE
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-3901c78894ab394d

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | TIMESTAMP WITH TIME ZONE | not recorded |
| val | TIMESTAMP | not recorded |

Declared return type: TIMESTAMP WITH TIME ZONE. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-cd63c28260372aaa

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: TIMESTAMP WITH TIME ZONE, val: TIMESTAMP WITH TIME ZONE) → TIMESTAMP WITH TIME ZONE
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-cd63c28260372aaa

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | TIMESTAMP WITH TIME ZONE | not recorded |
| val | TIMESTAMP WITH TIME ZONE | not recorded |

Declared return type: TIMESTAMP WITH TIME ZONE. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-8c70571bb4cbe25a

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: TIMESTAMP WITH TIME ZONE, val: VARCHAR) → TIMESTAMP WITH TIME ZONE
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-8c70571bb4cbe25a

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | TIMESTAMP WITH TIME ZONE | not recorded |
| val | VARCHAR | not recorded |

Declared return type: TIMESTAMP WITH TIME ZONE. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-42e116ebd6e725d9

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: TIMESTAMP, val: BIGINT) → TIMESTAMP
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-42e116ebd6e725d9

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | TIMESTAMP | not recorded |
| val | BIGINT | not recorded |

Declared return type: TIMESTAMP. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-7225e5f39929c776

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: TIMESTAMP, val: BLOB) → TIMESTAMP
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-7225e5f39929c776

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | TIMESTAMP | not recorded |
| val | BLOB | not recorded |

Declared return type: TIMESTAMP. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-6ab27ecdaf789732

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: TIMESTAMP, val: DATE) → TIMESTAMP
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-6ab27ecdaf789732

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | TIMESTAMP | not recorded |
| val | DATE | not recorded |

Declared return type: TIMESTAMP. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-515a2a06a3fb519c

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: TIMESTAMP, val: DOUBLE) → TIMESTAMP
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-515a2a06a3fb519c

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | TIMESTAMP | not recorded |
| val | DOUBLE | not recorded |

Declared return type: TIMESTAMP. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-a70158385641e8ba

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: TIMESTAMP, val: HUGEINT) → TIMESTAMP
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-a70158385641e8ba

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | TIMESTAMP | not recorded |
| val | HUGEINT | not recorded |

Declared return type: TIMESTAMP. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-38c314c70c61d939

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: TIMESTAMP, val: INTEGER) → TIMESTAMP
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-38c314c70c61d939

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | TIMESTAMP | not recorded |
| val | INTEGER | not recorded |

Declared return type: TIMESTAMP. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-b745d96703f34e27

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: TIMESTAMP, val: TIMESTAMP) → TIMESTAMP
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-b745d96703f34e27

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | TIMESTAMP | not recorded |
| val | TIMESTAMP | not recorded |

Declared return type: TIMESTAMP. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-2416cf4c897d7ff4

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: TIMESTAMP, val: TIMESTAMP WITH TIME ZONE) → TIMESTAMP
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-2416cf4c897d7ff4

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | TIMESTAMP | not recorded |
| val | TIMESTAMP WITH TIME ZONE | not recorded |

Declared return type: TIMESTAMP. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-de217735eb97d0de

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: TIMESTAMP, val: VARCHAR) → TIMESTAMP
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-de217735eb97d0de

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | TIMESTAMP | not recorded |
| val | VARCHAR | not recorded |

Declared return type: TIMESTAMP. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-b91324a5040691c1

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: VARCHAR, val: BIGINT) → VARCHAR
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-b91324a5040691c1

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | VARCHAR | not recorded |
| val | BIGINT | not recorded |

Declared return type: VARCHAR. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-de208abac8e161a8

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: VARCHAR, val: BLOB) → VARCHAR
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-de208abac8e161a8

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | VARCHAR | not recorded |
| val | BLOB | not recorded |

Declared return type: VARCHAR. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-e78df92c1bc33c95

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: VARCHAR, val: DATE) → VARCHAR
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-e78df92c1bc33c95

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | VARCHAR | not recorded |
| val | DATE | not recorded |

Declared return type: VARCHAR. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-e236f30e0c6fa620

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: VARCHAR, val: DOUBLE) → VARCHAR
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-e236f30e0c6fa620

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | VARCHAR | not recorded |
| val | DOUBLE | not recorded |

Declared return type: VARCHAR. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-a06db911a329aee2

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: VARCHAR, val: HUGEINT) → VARCHAR
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-a06db911a329aee2

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | VARCHAR | not recorded |
| val | HUGEINT | not recorded |

Declared return type: VARCHAR. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-2becb890c03b6e47

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: VARCHAR, val: INTEGER) → VARCHAR
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-2becb890c03b6e47

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | VARCHAR | not recorded |
| val | INTEGER | not recorded |

Declared return type: VARCHAR. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-e7da78b603d86fed

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: VARCHAR, val: TIMESTAMP) → VARCHAR
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-e7da78b603d86fed

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | VARCHAR | not recorded |
| val | TIMESTAMP | not recorded |

Declared return type: VARCHAR. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-6e45ea2f4b93dfe7

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: VARCHAR, val: TIMESTAMP WITH TIME ZONE) → VARCHAR
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-6e45ea2f4b93dfe7

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | VARCHAR | not recorded |
| val | TIMESTAMP WITH TIME ZONE | not recorded |

Declared return type: VARCHAR. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-f309ec3468eb3827

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: VARCHAR, val: VARCHAR) → VARCHAR
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-f309ec3468eb3827

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | VARCHAR | not recorded |
| val | VARCHAR | not recorded |

Declared return type: VARCHAR. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-d79c9572ccf781ee

Kind: aggregate. Parameter order: catalog-order.

```text
arg_max(arg: ANY, val: ANY, col2: BIGINT) → ANY[]
```

Link: /products/haybarn/functions/releases/duckdb-1.5.5/arg_max/#overload-d79c9572ccf781ee

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| arg | ANY | not recorded |
| val | ANY | not recorded |
| col2 | BIGINT | not recorded |

Declared return type: ANY[]. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.


## Guide recipes

No guide recipes.

## Engine catalog examples

Source examples may require additional data or extensions. Expressions are wrapped in SELECT; execution verification is not recorded.

Reported for: overload-7a13cd64de4d1d57, overload-8af6a66932f47f6e, overload-f518d6c0f0a1da08, overload-0905ae7763faacb1, overload-31e60c1fc95ec249, overload-e71eb89d2847860c, overload-d25d2cdedcef39cf, overload-bc66245450296d53, overload-6994f06e5c8b45c0, overload-54cbab4aff0b9161, overload-6fa435197cb4b0f4, overload-66d6bd89c95f59bf, overload-25e7a8e7afeb663a, overload-cb380c4575ec6e9c, overload-cc7da9ef3380a4ba, overload-9a46d6fc0c9acef0, overload-3c9e05990da128e2, overload-ab8b29bf1676924c, overload-b8c942ff8eef9891, overload-4222d3d4fba43f31, overload-b5121a4af955dd9b, overload-e798732a7d1542a8, overload-33107e088955a655, overload-d3c866a9f23a2f5f, overload-1224567de6e1693b, overload-1f9240e4fa20d261, overload-599996b4117e1054, overload-be3fcd3bcc4cc5a2, overload-1face098a76423ff, overload-1c6a251a20a76979, overload-9259159219cd4a86, overload-f70426ec2654db32, overload-af6969ef3f056ede, overload-261969f50c62f7cd, overload-dddc1244f06d77d5, overload-65edfd4a1eed42f1, overload-f76bb49496e91ea2, overload-929f7fc31b9b3e3e, overload-93d5f0a5d7131e15, overload-f84f20e2cbe9c8fb, overload-dcb95e327c7efc08, overload-4da1ff2df1a8692f, overload-cbbd29631206f083, overload-4f5bf1d783009bf0, overload-66668253642d62d6, overload-b645c32db667fd70, overload-e1c36a72e245187a, overload-a47acddb2c378efc, overload-2ed8cdee645c88a4, overload-e7f25b0da1a20041, overload-77cdb387565cc05d, overload-abbb813e8a0e47bb, overload-1a7487471b7a2295, overload-cd3046965902c896, overload-f6e0ab4cd9e7c5ea, overload-45c3722bfa95a48b, overload-07cf10a23be1aff6, overload-62acc52261dbcce0, overload-dfd6e7cf3731ed04, overload-338f56f075a0471b, overload-b63676408ef94995, overload-df62ac2716b062a8, overload-7f9162fba25dabfa, overload-71db361695a57d5a, overload-d3c6c1e11dc66648, overload-b48fcfbfabccd4ec, overload-3120d4a422e14167, overload-9dd3801de9955c95, overload-919c4490fe047353, overload-548d16ded4ba47aa, overload-3901c78894ab394d, overload-cd63c28260372aaa, overload-8c70571bb4cbe25a, overload-42e116ebd6e725d9, overload-7225e5f39929c776, overload-6ab27ecdaf789732, overload-515a2a06a3fb519c, overload-a70158385641e8ba, overload-38c314c70c61d939, overload-b745d96703f34e27, overload-2416cf4c897d7ff4, overload-de217735eb97d0de, overload-b91324a5040691c1, overload-de208abac8e161a8, overload-e78df92c1bc33c95, overload-e236f30e0c6fa620, overload-a06db911a329aee2, overload-2becb890c03b6e47, overload-e7da78b603d86fed, overload-6e45ea2f4b93dfe7, overload-f309ec3468eb3827, overload-d79c9572ccf781ee

```sql
SELECT arg_max(A, B);
```

## Runnable examples

Executed successfully in Haybarn WASM 1.5.5-rc3. Sample data and guide examples are separate from the original catalog.

```sql
SELECT arg_max(A, B)
FROM (VALUES
  (10, 10),
  (20, 20),
  (NULL, NULL)
) AS sample("A", "B");
```

## Additional DuckDB documentation

- [Aggregate Functions](https://duckdb.org/docs/current/sql/functions/aggregates#arg_maxarg-val-n)

## In other engines

### BigQuery: max_by()



BigQuery:

```sql
SELECT MAX_BY(name, score) FROM table1
```

Haybarn / DuckDB:

```sql
SELECT ARG_MAX(name, score) FROM table1
```

Translation from [SQLGlot](https://github.com/tobymao/sqlglot/blob/3086608e6fd4c41c02dfba47171608d2b193fce2/tests/dialects/test_bigquery.py#L2836).

### Presto: max_by()



Presto:

```sql
SELECT MAX_BY(a.id, a.timestamp) FROM a
```

Haybarn / DuckDB:

```sql
SELECT ARG_MAX(a.id, a.timestamp) FROM a
```

Translation from [SQLGlot](https://github.com/tobymao/sqlglot/blob/3086608e6fd4c41c02dfba47171608d2b193fce2/tests/dialects/test_presto.py#L820).

### Snowflake: max_by()



Snowflake:

```sql
SELECT MAX_BY(a, b) FROM t
```

Haybarn / DuckDB:

```sql
SELECT ARG_MAX(a, b) FROM t
```

Translation from [SQLGlot](https://github.com/tobymao/sqlglot/blob/3086608e6fd4c41c02dfba47171608d2b193fce2/tests/dialects/test_snowflake.py#L6044).

## Observed availability

| Snapshot | Observed | Overloads | JSON |
| --- | --- | --- | --- |
| haybarn-1.5.5-rc3 | present | 92 | [reference](/products/haybarn/functions/api/v1/haybarn-1.5.5-rc3/functions/arg_max.json) |
| duckdb-1.5.5 | present | 92 | [reference](/products/haybarn/functions/api/v1/duckdb-1.5.5/functions/arg_max.json) |
| duckdb-1.4.4 | present | 92 | [reference](/products/haybarn/functions/api/v1/duckdb-1.4.4/functions/arg_max.json) |
| duckdb-1.3.2 | present | 92 | [reference](/products/haybarn/functions/api/v1/duckdb-1.3.2/functions/arg_max.json) |

Engine catalog documentation is derived from MIT-licensed Haybarn and DuckDB. [Notices](/third-party-notices.txt).