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]
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]