mysqlは最も古い年齢を持つ重複した名前のリストを検索します

mysql 重複する名前と最も古い年齢を持つリストを検索

<br />
mysql> select count(*) as count  ,name,sum(age) as age from t1 group by name order by count desc;<br />
+-------+--------+------+<br />
| count | name   | age  |<br />
+-------+--------+------+<br />
|     3 | atest  |   64 |<br />
|     2 | btest  |   37 |<br />
|     2 | ctest  |   43 |<br />
|     2 | dtest  |   43 |<br />
|     1 | mary   |   22 |<br />
|     1 | kou    |   22 |<br />
|     1 | perter |   23 |<br />
|     1 | kate   |   19 |<br />
+-------+--------+------+<br />
8 rows in set (0.00 sec)<br />

count の重複データをここで見つけます
次に、カウントが最も大きいデータと、同じ年齢のデータを見つけます

<br />
mysql> select count,name,age from ( select count(*) as count  ,name,sum(age) as age from t1 group by<br />
 name order by count desc ,age desc ) as tmp group by count order by count desc ,age desc;<br />
+-------+--------+------+<br />
| count | name   | age  |<br />
+-------+--------+------+<br />
|     3 | atest  |   64 |<br />
|     2 | ctest  |   43 |<br />
|     1 | perter |   23 |<br />
+-------+--------+------+<br />
3 rows in set (0.00 sec)<br />

dtest の項目が 1 つ欠落しているのはなぜですか? dtest と ctest のデータはカウントと年齢の点で同じです。

アドバイスをお願いします！ありがとう

共有先:
-----解決策--------
tmp1.count,tmp1 を選択します。 from (年齢として count,max(age) を選択 from (カウント (*) として count ,name,sum(age) を年齢として選択 from t1 group by
name order by count desc ,age desc ) as tmp group by count order by count desc ,age desc) as tempd,( select count(*) as count ,name,sum(age) as age from t1 group by
name order by count desc ,age desc ) as tmp1 where tmp1.count=tempd.count および tmp1.age=tempd.age count order by tmp1.count desc ,tmp1.age desc;