SQLSERVER分页查询关于使用Top方式和row_number()解析

select  页大小 
from 表名
where id not in
(
select  页大小(查询第几页-1) id from 表名 order by id
)
order by id 

select  10  --10 为页大小
from [TCCLine].[dbo].[CLine_CommonImage]
where id not in
(
--40是这么计算出来的10(5-1)
-- 页大小（查询第几页-1）
select  40 id from [TCCLine].[dbo].[CLine_CommonImage] order by id
)
order by id

/
 firstIndex:起始索引
 pageSize:每页显示的数量
 orderColumn:排序的字段名
 SQL:可以是简单的单表查询语句，也可以是复杂的多表联合查询语句
/
select  pageSize o. from (select row_number() over(order by orderColumn) as rownumber, from(SQL) as o where rownumber>firstIndex; 

select  10 numComImg. from 
( select row_number() over(order by id asc) as rownumber, from (select  FROM [TCCLine].[dbo].[CLine_CommonImage]) as Img)
as numComImg where rownumber>40 

SET STATISTICS TIME ON
GO 

SET STATISTICS TIME ON
GO
select  10 numComImg. from 
( select row_number() over(order by id asc) as rownumber, from (select  FROM [TCCLine].[dbo].[CLine_CommonImage]) as Img)
as numComImg where rownumber>40
SET STATISTICS TIME ON
GO
select  10  --10 为页大小
from [TCCLine].[dbo].[CLine_CommonImage]
where id not in
(
--40是这么计算出来的10(5-1)
-- 页大小（查询第几页-1）
select  40 id from [TCCLine].[dbo].[CLine_CommonImage] order by id
)
order by id