Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi folks, i´m having a problem with ADDMONTHS in a table graph.
I´have a simple structura like that:
[Codigos]:
CODIGO (INTEGER),
DT_COMPETENCIA_INICIAL (DATE);
[Periodos]:
CODIGO (INTEGER),
DT_COMPETENCIA_ATUAL (DATE),
FL_ATIVO {S,N}
At column(1), i need count CODIGO that have DT_COMPETENCIA_ATUAL = DT_COMPETENCIA_INICIAL + 30
At column(2), i need count CODIGO that have DT_COMPETENCIA_ATUAL = DT_COMPETENCIA_INICIAL + 60
And so on...
Thank you so much,
Please read these two documents: