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

 

第一种效率高