I would like how to translate the Ms Access SQL to Oracle SQL and use DECODE function:
RESULT1 : sum(decode(null,field1,0,field2,0,field3,0,1))
I need to translate this :
Sum ( IIf ( DateDiff("n",[DATE1], [DATE2] < 0.01, 1, 0) ) / ( IIf([RESULT1]=0, 1, [RESULT1]) )
Here the DateDiff function in Ms Access mean the Difference between DATE1 and DATE2 in number of MINUTES.
Thank a lot.