MODE

Applies to: ✅ Data 360 SQL ✅ Tableau Hyper API

Returns the most frequent input value. If there are multiple equally frequent values, returns an arbitrary one.

• <sort_expression>: An expression of any sortable type that determines the value to find the mode of.

Returns the same type as the sort expression. Returns NULL if no rows are selected.

• This is an ordered-set aggregate function.
• NULL values in the sorted input are ignored.
• When multiple values have the same highest frequency, the choice between them is arbitrary.

Get the most frequently occurring category.

Find the most common value for each group.

• PERCENTILE_CONT
• PERCENTILE_DISC
• Aggregate Functions