SQL SERVER大数据分页

9/1/2015来源:SQL技巧人气:1324

SQL SERVER大数据分页select*from(selectrownumr,a.*from(select*fromtable_nameorderbyndatetimedesc)awhererownum<=currentPage*pageSize)wherer>(currentPage-1)*pageSize