摘要:
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
古文觀芷
閱讀(672)
評論(0)
推薦(1)
浙公網安備 33010602011771號