sql分页语句

在数据库中进行分页，比伪分页效率更高

 

select top pageSize * from table where id not in (select top (currentPage - 1)*pageSize id from table)