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
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