SqlServer 数据分页

 select * from

　　(

　　select ROW_NUMBER() over (partition by name order by name) rowid,* from table

　　)  t

where t.rowid between 0 and 10