表1:
classid,itemname,plansale,planprofit,week,month表2:
classid,itemname需要的结果:
concat(classid,itemname),plansale
第二列的plansale计算统计week='第五周'并且group by concat(classid,itemname)这个要怎样写sql语句?
classid,itemname,plansale,planprofit,week,month表2:
classid,itemname需要的结果:
concat(classid,itemname),plansale
第二列的plansale计算统计week='第五周'并且group by concat(classid,itemname)这个要怎样写sql语句?
sum( if( week='第五周', plansale, 0 ) ) as plansale
from 表1
group by concat(classid,itemname)