mysql 众数函数

SELECT column_name, COUNT(*) AS frequency
FROM table_name
GROUP BY column_name
ORDER BY frequency DESC
LIMIT 1;

CREATE TABLE student_scores (
    id INT AUTO_INCREMENT PRIMARY KEY,
    score INT
);

INSERT INTO student_scores (score) VALUES (85), (90), (85), (78), (90), (85);

SELECT score, COUNT(*) AS frequency
FROM student_scores
GROUP BY score
ORDER BY frequency DESC
LIMIT 1;

+-------+-----------+
| score | frequency |
+-------+-----------+
|    85 |         3 |
+-------+-----------+

SELECT score, COUNT(*) AS frequency
FROM student_scores
GROUP BY score
HAVING frequency = (
    SELECT MAX(frequency)
    FROM (
        SELECT score, COUNT(*) AS frequency
        FROM student_scores
        GROUP BY score
    ) AS subquery
);