select * from (select rownum r, a.* from (select * from table_name order by ndatetime desc ) a where rownum <= currentPage * pageSize ) where r > (currentPage - 1) * pageSize
SQL SERVER大数据分页,布布扣,bubuko.com
SQL SERVER大数据分页
原文：http://www.cnblogs.com/mr-hero/p/3775052.html
