mode ​

Select the most frequent non-NULL native value using the selected collation.

Syntax

mode() WITHIN GROUP(ORDER BY value [ASC|DESC]) or mode(value[,descending])

Returned value

Original native value; empty input gives NULL; FILTER/DISTINCT supported.

Examples

CREATE TABLE readings (value INTEGER);
INSERT INTO readings VALUES (1),(2),(2),(3);

SELECT mode() WITHIN GROUP(ORDER BY value) FROM readings FORMAT csv;

2