hi, suppose i have 400 entries in my table right, every record has 3 attributes, i.e.

S.no, Product Name, Product Company

now these 400 entries belongs to different companies about 20 apporximately. now i want that when i enter retrieve any 4 entries in whcih 2 belongs to 1 compnay and 3 belongs to other company, so it shows me data separately, mean to say that

colpol 123 compnay
panadol 123 compnay


piriton 44 compnay
incidal 44 company
broxol 44 compnay

how do i do it?