select a.地区,a.商场,sum(decode(a.品种,'单裤',57)) as 单裤,sum(decode(a.品种,'单裙',57)) as 单裙,sum(decode(a.品种,'风衣',57)) as 风衣,sum(decode(a.品种,'连衣裙',57)) as 连衣裙,sum(decode(a.品种,'毛衫',57)) as 毛衫,sum(decode(a.品种,'上衣',57)) as 上衣,sum(decode(a.品种,'外套',57)) as 外套,sum(decode(a.品种,'大衣',57)) as 大衣,a.结存,round(a.存销比,1) as cxb,b.lmj from 单店新款品种存销比 a ,单店基础信息表new b where a.地区||a.商场=b.region||b.unit group by a.地区||a.商场 ,a.存销比,b.lmj,a.结存 不是group by 语句? 哪出错了...
select a.地区,a.商场,sum(decode(a.品种,'单裤',57)) as 单裤,sum(decode(a.品种,'单裙',57)) as 单裙,sum(decode(a.品种,'风衣',57)) as 风衣,sum(decode(a.品种,'连衣裙',57)) as 连衣裙,sum(decode(a.品种,'毛衫',57)) as 毛衫,sum(decode(a.品种,'上衣',57)) as 上衣,sum(decode(a.品种,'外套',57)) as 外套,sum(decode(a.品种,'大衣',57)) as 大衣,a.结存,round(a.存销比,1) as cxb,b.lmj from 单店新款品种存销比 a ,单店基础信息表new b where a.地区||a.商场=b.region||b.unit group by a.地区||a.商场 ,a.存销比,b.lmj,a.结存 不是group by 语句? 哪出错了...
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货