查询学生总分排名前三的学生姓名：
SELECT score.`name` from score GROUP BY score.`name` HAVING SUM(score.score) in
(SELECT * from (SELECT DISTINCT (SUM(score.score)) from score GROUP BY score.`name` order by SUM(score.score) desc LIMIT 3) as t );
原文：https://www.cnblogs.com/Dovegege/p/9352190.html