查询总分前三名的人物（保函同分的情况）

SELECT
  NAME,
  SUM(fenshu) AS s
FROM users
GROUP BY NAME
HAVING s IN(SELECT
              sums
            FROM (SELECT
                    sums
                  FROM (SELECT
                          SUM(fenshu) AS sums
                        FROM users
                        GROUP BY NAME) AS su
                  GROUP BY sums
                  ORDER BY sums DESC
                  LIMIT 0,3) AS c)
ORDER BY s DESC;