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.

1mode() WITHIN GROUP (ORDER BY <sort_expression>)

• <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.

1SELECT mode() WITHIN GROUP (ORDER BY category) AS most_common_category
2FROM products;

Find the most common value for each group.

1SELECT region, mode() WITHIN GROUP (ORDER BY product_type) AS popular_product
2FROM sales
3GROUP BY region;

• PERCENTILE_CONT
• PERCENTILE_DISC
• Aggregate Functions