sql 查询重复数据个数并按照次数分组

Question

Answer 1

SELECT  *
FROM    ( SELECT    counts ,
                    COUNT(*) counts2
          FROM      ( SELECT    name ,
                                COUNT(*) AS counts
                      FROM      talbe***
                      GROUP BY  name
                    ) a
          GROUP BY  counts
        ) a
ORDER BY counts