declare classcur cursor for
select distinct class from table1
--创建一个临时表,结构与主表一致
select top 1 * into #tt from table1
delete from #tt
open classcur
declare @class varchar(100)
fetch next from classcur into @class
while @@fetch_status=0
begin
--找出前25名的学生,插入临时表中。
--其它处理也可以在这里完成。如判断是否第25名与后面几位的成绩一致,是否要查询出来。 insert into #tt
select top 25 * from table1 where class=@class order by score
fetch next from classcur into @class