存储过程分页方法

select top @pagesize *  from tb_product  A
LEFT join tb_product B  ON A.PROD_CODE = B.PROD_CODE
where B.id> @pagesize*@pageindex
ORDER BY A.ID ,B.ID