final simple where

WHERE NOT ( NVL("PTD Earning LC", 0) = 0 AND NVL(TO_NUMBER(REPLACE("PTD Earning (Latest HC)", ',', '')), 0) = 0 AND NVL("BB PTD Earning LC", 0) = 0 AND NVL(TO_NUMBER(REPLACE("BB PTD Earning (Latest HC)", ',', '')), 0) = 0 )

Comments

Popular posts from this blog

Child query new

child query latest -