SELECT NameFROM Candidate c INNER JOIN (SELECT CandidateId FROM Vote GROUP BY CandidateId ORDER BY COUNT(*) DESC LIMIT 1) AS wON c.id = w.CandidateId;
574. Winning Candidate
原文:https://www.cnblogs.com/yuesi/p/10163201.html