SQL分页

今天写一个报表需要用到sql分页，但是sql分页我知道limit

select * from table limit m,n

查了才知道这个是MySQL的语法，SQLServer limit 这个关键字都没有

SELECT d.book_type AS book_type, d.create_date AS create_date, d.booking_no AS booking_no, d.surname AS surname FROM(SELECT Row_Number() OVER ( ORDER BY c.id) AS rowNum, c.book_type, c.create_date, c.booking_no, c.surname FROM(SELECT DISTINCT o.id AS id,o.book_type AS book_type,o.create_date AS create_date,o.booking_no AS booking_no, ohc.surname AS surname  FROM [FareAdmin].[order] o LEFT JOIN [FareAdmin].[order_hotel] oh ON o.id = oh.order_idLEFT JOIN [FareAdmin].[order_hotel_contact] ohc ON oh.order_hotel_contact_id = ohc.idWHERE o.agentBookingRef is not null AND o.book_type = 1AND o.create_date < '2016-10-26'AND o.create_date > '2016-09-01'AND o.booking_no = 'PGGI08018') AS c) AS dwhere d.rowNum BETWEEN 1 AND 10

在网上查了一大堆。终于找到可用的方法，如上