正常情況下（要求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
 
arrow
arrow
    全站熱搜

    戮克 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄