[Solved] How to get maximum number of products matched vendors list. But i don’t want to check same products again [closed]


Use Count with Order by

Select Count(pro_id) as total From table 
Group by vendor_id Order by Count(pro_id)

2

solved How to get maximum number of products matched vendors list. But i don’t want to check same products again [closed]