MODE

引入或更新: v1.2.647

返回一组值中出现频率最高的值。

语法

MODE(<expr>)

示例

此示例从销售数据中识别每个月最畅销的产品：

CREATE OR REPLACE TABLE sales (
    sale_date DATE,
    product_id INT,
    quantity INT
);

INSERT INTO sales (sale_date, product_id, quantity) VALUES
    ('2024-01-01', 101, 10),
    ('2024-01-02', 102, 15),
    ('2024-01-02', 101, 10),
    ('2024-01-03', 103, 8),
    ('2024-01-03', 101, 10),
    ('2024-02-01', 101, 20),
    ('2024-02-02', 102, 15),
    ('2024-02-03', 102, 15);

SELECT MONTH(sale_date) AS month, MODE(product_id) AS most_sold_product
FROM sales
GROUP BY month
ORDER BY month;

┌─────────────────────────────────────┐
│      month      │ most_sold_product │
├─────────────────┼───────────────────┤
│               1 │               101 │
│               2 │               102 │
└─────────────────────────────────────┘