DECLARE @a int set @a = 1 while @a < 5 BEGIN select top(1) * from QPShuGameMatchDB..MatchScoreStatistics where UserID in ( select top (@a) UserID from QPShuGameMatchDB..MatchScoreStatistics order by Score desc ) order by Score; set @a = @a + 1 END
原文：http://blog.csdn.net/liujiayu2/article/details/46636493