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_id
		LEFT JOIN [FareAdmin].[order_hotel_contact] ohc ON oh.order_hotel_contact_id = ohc.id
		WHERE o.agentBookingRef is not null 
		AND o.book_type = 1
		AND o.create_date < '2016-10-26'
		AND o.create_date > '2016-09-01'
		AND o.booking_no = 'PGGI08018'
	) AS c
) AS d
where d.rowNum BETWEEN 1 AND 10

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