摘要:
select (select RowNum from(select row_number()over(order by Achievement_Content desc) as RowNum,* from FM_Achievement table1 where table1.Achievement_ExamId=FM_Achievement.Achievement_ExamIdand table1.Achievement_SubjectId=FM_Achievement.Achievement_SubjectId and table1.Sid=FM_Achievement.Sid) table 阅读全文
摘要:
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 阅读全文