获取最大时间插入MySQL结果的记录

Question

I have some data row in my table.

I want to select the Age which occurs the most.

Person | Group | Age
---
Bob  | 1     | 32  
Jill | 1     | 32  
Shawn| 1     | 42  
Jake | 2     | 29  
Paul | 2     | 36  
Laura| 2     | 39

Desired set:

The age that appears the most is 32.

Answer 1

Try something like this

SELECT Person,Group,Age,MAX(field_name)  
FROM table_name;