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

by

[ad_1]

Use Count with Order by

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

2

[ad_2]

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