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

Select most common value from a field in MySQL(从 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

这篇关于从 MySQL 的字段中选择最常见的值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！