代码改变世界

SQL server 分页

2012-03-20 11:04 by TJHan, 99 阅读, 0 推荐, 收藏, 编辑
摘要：WITHDemoTableNameAS(SELECT ROW_NUMBER()OVER (Order byColumnName ) as RowNumber,* fromTableName)SELECT *FROMDemoTableNameWHERE RowNumber betweenbeginPageNbr and endPageNbr 阅读全文