摘要: 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 阅读全文
posted @ 2010-10-28 11:08 啊汉 阅读(660) 评论(0) 推荐(1) 编辑