分页查询

A:SELECT * FROM CF_User ORDER BY Userid OFFSET 5 rows FETCH NEXT 10 rows only  --跳过前面5行取10行

B:select *from (select * ,row_number() over(order by userid) rows from cf_user )t where t.rows between 1 and 10