sqlserver2012 offset分页

select ID,UserName from user order by ID OFFSET (10 * (50-1)) ROW FETCH NEXT 10 rows only
原文地址:https://www.cnblogs.com/zhaogaojian/p/10163975.html