MySQL选择具有相同条件值的顶部行

我认为这是正确的解决方案：您需要子查询才能知道在前十名中排名第十的职位有多少。然后，您可以使用外部查询来提取具有几乎该后计数的用户。

SELECt u.username, COUNT(p.id) AS count FROM Posts pJOIN Users u ON u.id = p.author_idGROUP BY p.author_id HAVINg COUNT(p.id) >= (    SELECt COUNT(p.id) AS count     FROM Posts p    JOIN Users u ON u.id = p.author_id    GROUP BY p.author_id     ORDER BY count DESC    LIMIT 9, 1)ORDER BY count DESC