Problema group by no Oracle

[fsitjaParticipante]

A função trunc() remove a parte das horas e minutos:


SELECT L.NUM_REQUISICAO,
TRUNC(I.DATA_INT) DATA_INT,
TRUNC(L.DATA2) DATA2
FROM TABELA1 L,
TABELA2 I
WHERE L.NUM_REQ = I.NUM_PED
GROUP BY L.NUM_REQUISICAO,
TRUNC(I.DATA_INT),
TRUNC(L.DATA2)
ORDER BY L.NUM_REQUISICAO