SQL ROW_NUMBER() VS TOP

ROW_NUMBER() 的SQL語句:

 select * from (
     select ID , ArchivesTypeID,SegmentColumnName,SegmentDisplayText,SegmentOrderID,

     SegmentSeparator,ROW_NUMBER() over(order by  ID desc ) as RowNum   from MytestTable ) table1
 where RowNum  between  1700000 and  1710040

TOP 的SQL語句

 WITH temp AS (select ID , ArchivesTypeID,SegmentColumnName,SegmentDisplayText,

      SegmentOrderID,SegmentSeparator from MytestTable )
 select top  10040 * from  temp where id>(
     select max(id) from (select top  1700000 ID from temp order by id)table2
 ) order by ID

記錄的總條數(shù) select COUNT(*) from MytestTable 共2399998條

ROW_NUMBER()用時2秒

TOP用時0秒