I have the following table:
Consideringthattodayis02/01/2019,whenmakingthepivottablebelow:
SELECThora,CASEWHENdata=CURDATE()THENtarefaELSENULLENDAScampo_1FROMtabelaWHEREdataBETWEENCURDATE()ANDDATE_ADD(CURDATE(),INTERVAL2DAY)GROUPBYhora,dataORDERBYhora
Igetthefollowingoutput:
ButI'dliketoget:
All help is welcome, thank you