01 table 查詢 500~1000

Post date: 2013/11/15 上午 03:11:41

select *

from ( select ROW_NUMBER() over (order by ExamPracticeID asc) rownum,

*

from [LearningKing].[dbo].[ExamPractice] ) as yourselect

where rownum between 0 and 10

order by ExamPracticeID desc