血泪

摘要： Row_number 分页select * from (select row_number() over(order by id) as rownumber,id from test) as d 　　where rownumber (CurrentPageIndex - 1) * PageSize and rownumber=CurrentPageIndex * PageSize) 适用于sql 2005 及以上TOP分页（1）select top PageSize * from test 　　where id(select max(id) from 　　　　(select top Pa 阅读全文