摘要:
ROW_NUMBER() 的SQL语句:select * from ( select ID , ArchivesTypeID,SegmentColumnName,SegmentDisplayText,SegmentOrderID, SegmentSeparator,ROW_NUMBER() over(order by ID desc ) as RowNum from MytestTable ) table1where RowNum between 1700000 and 1710040TOP 的SQL语句WITH temp AS (select ID , ArchivesTypeID,Segm 阅读全文