sqlserver 分頁

select top 10 numComImg.* from

( select row_number() over(order by id asc) as rownumber,* from (select * FROM [TCCLine].[dbo].[CLine_CommonImage]) as comImg)

as numComImg where rownumber>40

select top 10 * --10 為頁大小

from [TCCLine].[dbo].[CLine_CommonImage]

where id not in

(

--40是這么計算出來的：10*(5-1)

-- 頁大小*（查詢第幾頁-1）

select top 40 id from [TCCLine].[dbo].[CLine_CommonImage] order by id

)

order by id

第一種效率高