Docs

ByteHouse Enterprise Edition

Aggregate function

Min/Max

argMax

Calculate the val arg corresponding to the .
Syntax ```SQL
argMax(arg, val)

</span> 

**Param** 

* <span style="background-color: var(--ifm-code-background)"><code>arg</code></span> — Argument. 
* <span style="background-color: var(--ifm-code-background)"><code>val</code></span> — Value. 

**Return value** 

* <span style="background-color: var(--ifm-code-background)"><code>val</code></span> The <span style="background-color: var(--ifm-code-background)"><code>arg</code></span> value corresponding to the Maximum Value. 

Type: Match <span style="background-color: var(--ifm-code-background)"><code>arg</code></span> type. 
**Example** 
Input table: 
<span style="background-color: initial">```Plain Text 
┌─user─────┬─salary─┐ 
│ director │   5000 │ 
│ manager  │   3000 │ 
│ worker   │   1000 │ 
└──────────┴────────┘

Search: ```SQL
SELECT argMax(user, salary), argMax(tuple(user, salary), salary) FROM salary;

</span> 

As a result: 
<span style="background-color: initial">```Plain Text 
┌─argMax(user, salary)─┬─argMax(tuple(user, salary), salary)─┐ 
│ director             │ ('director',5000)                   │ 
└──────────────────────┴─────────────────────────────────────┘

# argMin Syntax: argMin(arg, val) or argMin(tuple(arg, val)) Calculate the arg corresponding to the val . **Example:** table: ```Plain Text ┌─user─────┬─salary─┐ │ director │ 5000 │ │ manager │ 3000 │ │ worker │ 1000 │ └──────────┴────────┘ ```

Search: ```SQL
SELECT argMin(user, salary), argMin(tuple(user, salary), salary) FROM salary;

</span> 

As a result: 
<span style="background-color: initial">```Plain Text 
┌─argMin(user, salary)─┬─argMin(tuple(user, salary), salary)─┐ 
│ worker               │ ('worker',1000)                     │ 
└──────────────────────┴─────────────────────────────────────┘

# Max Calculate the Maximum Value. # Min Calculate the Low.

Last updated: 2026.03.31 11:50:00