count top 10 most occuring values in a column in mysql

Question

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

I have a column in mysql table that has the the data type INT(11).

How can I search to get the top 10 most occurring values in this column?

See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…

649 views

1 Answer

深蓝 · Answer 1 · 2021-10-17T00:48:37+0000

answered Oct 17, 2021 by 深蓝 (71.8m points)

SELECT col, count(*)
    FROM tablethingie
    GROUP BY col
    ORDER BY count(*) DESC
    LIMIT 10

与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…