CASE WHEN NVL(BAT_WK02,0)>=NVL(TARGET_BAT,0) THEN
CASE WHEN NVL(RMO_ENTITLED_WK01,0)>0 THEN NVL(SKU_SALES_WK02,0) >= NVL(TARGET_SKU,0) THEN NVL (TARGET_SKU,0) * 1 ELSE NVL(SKU_SALES_WK02,0) *1WHEN NVL(RMO_ENTITLED_
WHEN GREATEST(NVL(MOV.NUMMOVNRODIASCAP,0), NVL(MOV.NUMMOVNRODIASINT,0)) >=91 AND GREATEST(NVL(MOV.NUMMOVNRODIASCAPNVL(MOV.NUMMOVNRODIASINT,0)) >=181 AND GREATEST(NVL(MOV.NUMMOVNRODIASCAP,0), NVL(MOV.NUMMOVNRODIASINTNVL(MOV1.NUMMOVN
my query:
OUTLET_NAME,ROUND((nvl(SUM(SALES_VALUE),0)+nvl(sum(total_sales),0)-nvl(sum(net_sales),0)+nvl(sum(discount),0))/nvl(sum(BILLS_WITHOUT_CGROUP),0))ASPB,
(SUM(ef.PIPELINE),0) AS PIPELINE, NVL(SUM(ef.FORECAST),0) AS FORECAST,
CASE fc.FREQUENCY WHEN '%' THEN NVL(SUM(ef.PIPELINE_DIFF)'W' THEN NVL(SUM(ef.W_PIPELI
我正在努力实现与NVL和NVL2的合并功能。它似乎与NVL合作得很好。然而,NVL2并没有给出想要的结果。我是不是错过了一些NVL2的东西。from dualselect null, null, 'c' from dual)它提供了想要的输出同样的事情,我想用NVL2实现,它没有给出欲望的结果。null from dua