select (row_number()over(order by dabh)-1)/20[groupby] from v_payroll
按每20条分组查询
原文:http://www.cnblogs.com/hllive/p/7253037.html