SqlServer 数据分页

 select * from
  (
  select ROW_NUMBER() over (partition by name order by name) rowid,* from table
  )  t
where t.rowid between 0 and 10
posted @ 2017-06-30 09:29  帕丁顿熊  阅读(214)  评论(0编辑  收藏  举报