sql遍历所有数据集，sql遍数据

sql遍历所有数据集，sql遍数据

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