Boa tarde,
estou com este Select e gostaria de colocar um Extract Month dentro dele será possível?
SELECT L1.* FROM apontamento As L1
INNER JOIN (
SELECT NUM_OF, MAX(Datahora) As UltimaData
FROM apontamento GROUP BY NUM_OF) As L2
ON L1.NUM_OF = L2.NUM_OF AND L1.Datahora = L2.UltimaData
where
L1.pa <> 0 and
L1.datahora >= :DataIni and
L1.datahora <= :DataFim
ORDER BY L1.datahora