从 MySQL 的字段中选择最常见的值

2021-11-20 00:00:00 mysql

我有一个有一百万行的表格，我如何从一个字段中选择最常见(在表格中出现最多的值)的值?

I have a table with a million rows, how do i select the most common(the value which appears most in the table) value from a field?

推荐答案

您需要按感兴趣的列进行分组，并为每个值选择值本身及其出现的行数.

You need to group by the interesting column and for each value, select the value itself and the number of rows in which it appears.

然后是排序问题(将最常见的值放在首位)并将结果限制为仅一行.

Then it's a matter of sorting (to put the most common value first) and limiting the results to only one row.

在查询表单中:

SELECT column, COUNT(*) AS magnitude FROM table GROUP BY column ORDER BY magnitude DESC LIMIT 1

相关文章