mysql - 查找表的最常见值

Question

我如何在 lasthit 或 mostdamage 表 player_frags 中找到最常见的值并按 asc 排序？

SELECT DISTINCT(name) FROM players p 
INNER JOIN player_frags pf ON pf.lasthit = p.name 
OR pf.mostdamage = p.name

Answer 1

SELECT name FROM players p 
INNER JOIN player_frags pf ON pf.lasthit = p.name 
OR pf.mostdamage = p.name GROUP BY name Order By COUNT(*) DESC

您可以在最常见的名称末尾添加 LIMIT 1。

SQL Fiddle