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  帕丁顿熊  阅读(224)  评论(0)    收藏  举报