SqlServer 数据分页

 select * from
  (
  select ROW_NUMBER() over (partition by name order by name) rowid,* from table
  )  t
where t.rowid between 0 and 10
原文地址:https://www.cnblogs.com/peasana/p/7097326.html