每页10个记录,查询出第2页的记录

如果不带查询条件:

select top 10  * from WorkRecord
  where (Id not IN (select top (10 * 2) Id FROM WorkRecord))

如果带查询条件

select top 10  * from (select * FROM WorkRecord
  where (CatchTime > '2013/11/18 0:00:00' and CatchTime < '2013/12/18 23:59:59')) tag
  where (tag.Id not IN (select top (10 * 2) tag1.Id FROM (select * FROM WorkRecord
  where (CatchTime > '2013/11/18 0:00:00' and CatchTime < '2013/12/18 23:59:59')) tag1))

posted on 2013-12-19 11:37  pdfw  阅读(323)  评论(0编辑  收藏  举报