SqlServer实现my sql 的limit用法

SELECT * FROM
(
SELECT ROW_NUMBER()over(order by getdate()) AS rownumber,* from NDr2_AuthorSet
) AS #a
WHERE #a.rownumber>=10 AND #a.rownumber<=20