Sir ek product table hai usme se sare product uthane hai but first wo product show ho jis category ko select kiya gya hai baki uske neeche
like hamare pass 1 se 10 category hai and hmne 4 select kiya to phle category 4 ke product aaye and uske neeche baki category wise
select hnysku,title,Category,[Sub-Category] as subcat,AdditionalCategory,Additional_SubCategory
from hny_products where parentage='Parent'
group by hnysku,title,Category,[Sub-Category],AdditionalCategory,Additional_SubCategory
order by Category
isse data category wise arrange hoke aa rha hai but fir selected category ke liye kaise hoga please help