Repository navigation
Support max_by in Aggregation function #12252
Description
Is your feature request related to a problem or challenge?
| Description | Finds the row with the maximum val. Calculates the arg expression at that row. This function is affected by ordering. |
|---|---|
| Example | max_by(A, B) |
| Alias(es) | argMax(arg, val), arg_max(arg, val) |
Describe the solution you'd like
D SELECT max_by(x, y) FROM VALUES ('a', 10), ('b', 50), ('c', 20) AS tab(x, y);
┌──────────────┐
│ max_by(x, y) │
│ varchar │
├──────────────┤
│ b │
└──────────────┘Describe alternatives you've considered
No response
Additional context
https://duckdb.org/docs/sql/functions/aggregates#max_byarg-val
https://docs.databricks.com/en/sql/language-manual/functions/max_by.html
Activity
Lordworms commentedon Aug 30, 2024
take
korowa commentedon Sep 1, 2024
These probably could be an aliases (with some additional transformations) for first/last aggregation functions -- otherwise there it'll end with two implementations of basically the same function (not something bad, but still redundant).
Relevant discussion -- #12075
alamb commentedon Sep 9, 2024
Given #12357 we may want to move this function to some other repo rather than the core
alamb commentedon Sep 16, 2024
Suggestion: #12254 (comment)
alamb commentedon Sep 25, 2024
We are going to implement these in a different repository so closing this ticket to avoid confusion: #12254 (comment)
findepi commentedon Jul 16, 2025
I'd love to see
min_by&max_bywithin DataFusion repository.