SQLServer 分页(联合主键)

正常情况下（要求not in字段唯一）

select top pageSize * form table where id not in
  (select top pageSize*page-pageSize id from table order by id)order by id

或

select *  from(
select top pageSize * from(
select top pageSize*page * from table 
 where ...  order by id  ASC
)   as  t1 order by id   DESC
)   as  t2 order by id  ASC 

如果为联合主键（唯一）

select top pageSize * form table where id1+id2 not in
  (select top pageSize*page-pageSize id1+id2 from table order by id)order by id

评论

1 楼 李俊林 2012-02-13  

id1+id2有点问题吧