demusniko12 Posted November 25, 2020 Share Posted November 25, 2020 i used case when for 3 of my fields but when the field shoud've been null, they printed DE-12 from nowhere.my query selectCAST(a.vdate as date) as end_day,case when a.ccy = 'USD' and a.ctrccy = 'JPY' then sum(A.ccyamt*A.CCYRATE_8) else 0 end as usdjpy,case when a.ccy = 'USD' and a.ctrccy = 'SGD' then sum(A.ccyamt*A.CCYRATE_8) else 0 end as usdsgd,case when a.ccy = 'AUD' and a.ctrccy = 'USD' then sum(A.ccyamt*A.CCYRATE_8) else 0 end as audusd,case when a.ccy = 'USD' and a.ctrccy = 'IDR' then sum(A.ccyamt*A.CCYRATE_8) else 0 end as usdidr,COUNT(a.PRODCODE) as jumlah_transaksiFROM FXDH ALEFT JOIN CUST B ON A.CUST=B.CNOLEFT JOIN BROK C ON A.BROK=C.BROKNOLEFT JOIN TRAD D ON A.TRAD=D.TRADLEFT JOIN VW_SRHR E ON A.DEALDATE=E.TANGGAL AND A.CCY=E.CCY AND A.BR=E.BRgroup by a.CCY,a.CTRCCY,CAST(a.vdate as date)ORDER BY end_daythe previewed Link to comment Share on other sites More sharing options...
gustavofarias Posted November 25, 2020 Share Posted November 25, 2020 isn't it 0e-12? Meaning 0 with exponent -12. This is just E notation for a Exponentiation Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now