[RESOLVIDO]Ajuda com Query

[SamantaSParticipante]

[quote=”burga”:18s9e5ki]Tente filtrar com a cláusula HAVING ao invés de usar WHERE:

SELECT DISTINCT CODCOLIGADA, MAX(MESCOMP), MAX(ANOCOMP)
FROM PFPERFF
GROUP BY CODCOLIGADA
HAVING MAX(ANOCOMP) <= '2010'
ORDER BY CODCOLIGADA

Abraços,[/quote]

Muito obrigada!!!
Deu super certo.
Bjão