sql 取行号 得出排名 分页 显示 可列入条件,不要并列
select top 10 * from ( select row_number()over(order by Achievement_Content desc)as RowNum,* from FM_Achievement tabl1 where tabl1.Achievement_SubjectId=4494 and tabl1.Achievement_ExamId=198 and Sid=324 ) table2 where table2.RowNum>98