我的表中有一些数据行。
我想选择出现次数最多的Age。
Person | Group | Age
---
Bob | 1 | 32
Jill | 1 | 32
Shawn| 1 | 42
Jake | 2 | 29
Paul | 2 | 36
Laura| 2 | 39
所需的设置:
出现最多的年龄是32岁
使用以下查询
select Person, count(*) as c FROM tableName GROUP BY Age
您可以添加限制1来获得唯一的唯一记录,并通过排序来获得最大或最小年龄。使用以下查询
select Person, count(*) as c,Age FROM profile GROUP BY Age ORDER BY c desc LIMIT 0,1
试试这样
SELECT Person,Group,Age,MAX(field_name)
FROM table_name;
分组后,您可以按如下方式选择前1:这将选择32作为答案
SELECT TOP (1) Age
FROM tablename
GROUP BY age
ORDER BY COUNT(*) DESC
SELECT age FROM my_table GROUP BY age ORDER BY COUNT(*) DESC LIMIT 1;
很明显,在平局的情况下,这个结果会产生误导。