sql related Query Please help

Question

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