Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Feature] max_by, min_by aggregate function support #7678

Open
2 of 3 tasks
hf200012 opened this issue Jan 8, 2022 · 0 comments
Open
2 of 3 tasks

[Feature] max_by, min_by aggregate function support #7678

hf200012 opened this issue Jan 8, 2022 · 0 comments
Labels
area/sql/function Issues or PRs related to the SQL functions kind/feature Categorizes issue or PR as related to a new feature.

Comments

@hf200012
Copy link
Contributor

hf200012 commented Jan 8, 2022

Search before asking

  • I had searched in the issues and found no similar issues.

Description

max_by(x, y) Query the corresponding x value when y is the maximum value.
max_by(x, y, n) Query the x values corresponding to the largest n y values, and return the result as an array.
min_by(x, y) Query the corresponding x value when y is the minimum value.
min_by(x, y, n) Query the x value corresponding to the smallest n y values. The result is returned as an array.

Use case

No response

Related issues

No response

Are you willing to submit PR?

  • Yes I am willing to submit a PR!

Code of Conduct

@hf200012 hf200012 added kind/feature Categorizes issue or PR as related to a new feature. area/sql/function Issues or PRs related to the SQL functions labels Jan 8, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
area/sql/function Issues or PRs related to the SQL functions kind/feature Categorizes issue or PR as related to a new feature.
Projects
None yet
Development

No branches or pull requests

1 participant