Getting started
Use cases
Step-by-step instructions
Concepts
Access management
- Managing access to DataLens
- Managing access at the data row level
Pricing policy
- Current pricing policy
- Archive
  - Policy before March 1, 2021
Function reference
- All Functions
- Aggregate functions
- Date/Time functions
- Geographical functions
- Logical functions
  - Overview
  - CASE
  - IF
  - IFNULL
  - ISNULL
  - ZN
- Text markup functions
- Mathematical functions
  - Overview
  - ABS
  - ACOS
  - ASIN
  - ATAN
  - ATAN2
  - CEILING
  - COS
  - COT
  - DEGREES
  - DIV
  - EXP
  - FLOOR
  - GREATEST
  - LEAST
  - LN
  - LOG
  - LOG10
  - PI
  - POWER
  - RADIANS
  - ROUND
  - SIGN
  - SIN
  - SQRT
  - SQUARE
  - TAN
- Operators
- String functions
- Time series functions
- Type conversion functions
- Window functions
  - Overview
  - AVG
  - AVG_IF
  - COUNT
  - COUNT_IF
  - FIRST
  - LAG
  - LAST
  - MAVG
  - MAX
  - MCOUNT
  - MIN
  - MMAX
  - MMIN
  - MSUM
  - RANK
  - RANK_DENSE
  - RANK_PERCENTILE
  - RANK_UNIQUE
  - RAVG
  - RCOUNT
  - RMAX
  - RMIN
  - RSUM
  - SUM
  - SUM_IF
- Function Availability
Questions and answers

ARG_MAX

Syntax

ARG_MAX( value, comp )

Description

Returns value for the maximum value of comp in the group. If multiple values of value match the maximum value of comp, then the first one encountered is returned. This makes the function non-deterministic.

Argument types:

value — Any
comp — Any

Return type: Same type as (value)

Examples

ARG_MAX([Sales], [Profit])

Data source support

Materialized Dataset, ClickHouse 1.1.