This content has been marked as final. Show 6 replies
My code finally works and thank to all that help me until now
Well, i have this situation
I receive a OID_METER (numeric) and i join this field whith HOUR(of the last 3 consecutive days) and VALUE.
Now i need implant a rule that if i get value zero in any hour of any day i must delete this OID_METER from the row, that means, i just need to show OID_METER's that dont get any zero measure.
How can i delete a row in a field?
(ConsumoReal_0 > 0 AND ConsumoReal_1 > 0 AND ConsumoReal_2 > 0)
AND (ConsumoReal_0>0.005 OR ConsumoReal_1 >0.005 OR ConsumoReal_2>0.005)
AND (HORA0>=2 AND HOUR0<=5);
Sum(CONSUMODIA0)AS ConsumoReal_0, //consume of the day
Sum(CONSUMODIA1)AS ConsumoReal_1, //consume of the day -1
Sum(CONSUMODIA2)AS ConsumoReal_2 //consume of the day -2
ORDER BY HORA0 DESC;