2017年第33周

语法：

SELECT t.字段名 FROM (
SELECT 字段（可以是多表关联的字段） ,
row_number() over(order by 某个排序字段 desc) r 
FROM 表名 where 过滤条件 ) t 
where t.r <= (每页显示条数*要查询的页) and t.r > (每页显示条数*(要查询的页-1))

实例一：

SELECT *
FROM
(
  SELECT ROW_NUMBER( ) OVER( ORDER BY id ASC )
  AS rowNumber,
         *
  FROM
  (
    SELECT *
    FROM OPENQUERY( [10.100.254.101], 'select * from BJC_Finance.dbo.ISBG_Project' )
  )
  AS A
)
AS B
WHERE rowNumber BETWEEN 1 AND 5;

实例二：

select * from (select row_number() over (order by id) as row_num,* from table)
t where row_num between 1 and 30