摘要:
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
古文观芷
阅读(670)
评论(0)
推荐(1)
浙公网安备 33010602011771号