SQL中取出前三名的记录

select t.* from GameScore t where id in(select top 3 id from GameScore where GameID=t.GameID order by Score desc) order by Score desc

【推广】免费学中医，健康全家人

原文地址：https://www.cnblogs.com/yeagen/p/1564100.html