select count(*),shuxing,产品名称 from product group by shuxing,产品名称。 或用这个sql语句可以查出来select count(*),shuxing from product where 产品名称="..." group by shuxingselect count(*),shuxing from product where 产品名称="..." and shuxing like '%1%';select count(*),shuxing from product where 产品名称="..." and shuxing like '%2%';select count(*),shuxing from product where 产品名称="..." and shuxing like '%0%';
|