We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
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
mode
The most frequent value.
D SELECT mode(col) FROM VALUES ([1, 2]), ([1, 2]), ([2, 3]) AS tab(col); ┌───────────┐ │ mode(col) │ │ varchar │ ├───────────┤ │ [1, 2] │ └───────────┘ -- The function returns either 1 or 2, but not 3 > SELECT mode(col) FROM VALUES (1), (1), (2), (2), (3) AS tab(col); 1 > SELECT mode(col) FROM VALUES (NULL), (NULL) AS tab(col); NULL
No response
https://duckdb.org/docs/sql/functions/aggregates#modex https://docs.databricks.com/en/sql/language-manual/functions/mode.html
The text was updated successfully, but these errors were encountered:
take
Sorry, something went wrong.
Done for primitive/float types, working on bytes/views.
Given #12357 we may want to move this function to some other repo rather than the core
dmitrybugakov
Successfully merging a pull request may close this issue.
Is your feature request related to a problem or challenge?
The most frequent value.
Describe the solution you'd like
Describe alternatives you've considered
No response
Additional context
https://duckdb.org/docs/sql/functions/aggregates#modex
https://docs.databricks.com/en/sql/language-manual/functions/mode.html
The text was updated successfully, but these errors were encountered: