假设我有如下表格:
id | name
----------
01 | Tony
02 | Peter
03 | Tony
04 | Tony
05 | John
.. | ..
99 | David如何使用SQL语句获取最频繁的字段名(Tony)?
发布于 2011-05-11 10:41:04
大致是这样的:
SELECT name
FROM table_name
GROUP BY name
ORDER BY COUNT(*) DESC
LIMIT 1;发布于 2011-05-11 10:42:51
你要找的是Mode。本文解释了如何获取它(请看最后的代码示例):
http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/calculating-mean-median-and-mode-with-sq
发布于 2011-05-11 10:44:36
SELECT Name, COUNT(*)
FROM YourNames
GROUP BY Name
ORDER BY COUNT(*) DESC
LIMIT 1https://stackoverflow.com/questions/5958602
复制相似问题