mysql - 有没有办法按出现频率对 mysql 行进行排序？

Question

很难说出这里问的是什么。这个问题是含糊的、模糊的、不完整的、过于宽泛的或修辞性的，无法以目前的形式得到合理的回答。如需帮助澄清此问题以便重新打开它， visit the help center 。

已关闭 11 年前。

有没有一种方法可以按出现频率对 mysql 行进行排序？

Answer 1

SELECT n, count(*) as freq
FROM your_table
GROUP BY n
ORDER BY freq DESC;

更具体的例子:

SELECT n, count(*) as freq
FROM (
  SELECT 1 as n
  UNION ALL
  SELECT 2 as n
  UNION ALL
  SELECT 3 as n
  UNION ALL
  SELECT 3 as n
  UNION ALL
  SELECT 3 as n
  UNION ALL
  SELECT 2 as n) as your_table
GROUP BY n
ORDER BY freq DESC;

将返回:

n, freq
3, 3
2, 2
1, 1