其实123(提问者) select case a.validdate when trunc(a.validdate,\'dd\')<=sysdate then \'exppires_num\' when a.validdate-trunc(sysdate,\'dd\')<=60 then \'validdate_mum\' when trunc(sysdate,\'dd\')-trunc(b.createdate,\'dd\')>=90 then \'unsold_mum\' else \'cross_mum\' end,sum(a.snptagqty) from v_bi_centstock_percentage a,wms_inbound b where a.barcode=b.barcode and b.inboundtype=0 and exists (select 1 from wms_inbound a1 where a1.barcode=a.barcode and a1.inboundtype=0) group by a.validdate 麻烦看些这样写有什么问题吗？一直报错

回复

2021-07-28 16:06 

取消 回复

linboding 回复 其实123(提问者) 第一个a.validdate去掉，group by 后面也写case when 。。。

回复

2021-07-28 16:10 

取消 回复

linboding 回复 其实123(提问者) group by 还是多了a.validdate 你上网搜一下case when 的用法吧

回复

2021-07-28 16:23 

取消 回复

linboding 回复 其实123(提问者) 数字加上单引号

回复

2021-07-28 16:24 

取消 回复