分页sql语句

每页10条记录
 总共2596/10=259.6  == 260页 
第n页从记录数((n-1)*10) -> (n*10) 

1）  select top PageSize * from TableName where id not in (select top (StartRecord-1)*PageSize id from TableName order by id) order by id 

2）  select top PageSize * from TableName where id > (select max(id) from (select top startRecord-1 id from TableName order by id) as TempTable) order by id    

//PageSize是每頁資料,StartRecord第幾頁