MODE

MODE

Returns the most frequent element in a column/group/window, including #sql NULL if that is the element that appears the most. Supported on all non-semi-structured types.

Returns NULL if the input is all NULL or empty.

Note

In case of a tie, BodoSQL will choose a value arbitrarily based on performance considerations.