(首页) Select top 20 * from table order by ID (下一页)Select top 20 * from table where ID>当前页最后一条记录的ID order by ID (上一页)Select top 20 * from table where ID<当前页第一条记录的ID order by ID DESC(取出数据再order by ID) (末页) Select top 20 * from table order by ID DESC(取出数据再order by ID)
(下一页)Select top 20 * from table where ID>当前页最后一条记录的ID order by ID
(上一页)Select top 20 * from table where ID<当前页第一条记录的ID order by ID DESC(取出数据再order by ID)
(末页) Select top 20 * from table order by ID DESC(取出数据再order by ID)