现在用的是这种写法,感觉是不是有点太麻烦了 select outinman,id,outintime,sum(decode(dpmname,'夏装',dpmcount,0)) 数量,sum(decode(dpmname,'夏装',unitprice,0)) 单价 , sum(decode(dpmname,'夏装',unitprice*decode(dpmname,'夏装',dpmcount,0),0)) 金额 from tb_dpmintoout group by outinman,outintime,id
select outinman,id,outintime,sum(decode(dpmname,'夏装',dpmcount,0)) 数量,sum(decode(dpmname,'夏装',unitprice,0)) 单价
, sum(decode(dpmname,'夏装',unitprice*decode(dpmname,'夏装',dpmcount,0),0)) 金额 from tb_dpmintoout group by outinman,outintime,id