SqlServer2012增加的新分页方式 OFFSET/FETCH NEXT
语法
OFFSET=偏移，跳过 rows
FETCH = 取 rows only
示例
越过 1 万条，取 50 条
SELECT * from User ORDER BY UserID OFFSET 100000 ROW FETCH NEXT 50 ROW ONLY
相较于Row_number ()
相较于Row_number ()，Offset Fetch next 的性能更好
标签：OFFSET,number,Fetch,Offset,Next,FETCH From： https://www.cnblogs.com/idbb98/p/16954482.html