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