Can an aggregate function be added for statistical mode?

You are viewing an old version of this article. View the current version here.

Most sql engines (except postgres) don't seem to have a statistical mode function and I think I understand why it was not implemented years ago because it would be more resource intensive than a simple count, min, max or average. However computing power has evolved drastically and so I am surprised that this hasn't been added as a core group by function.

My ideal MODE() function would return NULL if there is no mode and if there are multiple values, it would return them comma separated like GROUP_CONCAT().


Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.