Galera, existe algum jeito especial de fazer o group by numa consulta usando JPQL?
Estou tentando fazer desse jeito:
Mas gera o seguinte erro
SELECT codigoNivel1 FROM FatoDespesa GROUP BY codigoNivel1 ORDER BY unidadeOrcamentaria DESC
Caused by: Exception [EclipseLink-8024] (Eclipse Persistence Services - 2.3.2.v20111125-r10461): org.eclipse.persistence.exceptions.JPQLException
Exception Description: Syntax error parsing the query [SELECT codigoNivel1 FROM FatoDespesa GROUP BY codigoNivel1 ORDER BY unidadeOrcamentaria DESC], line 1, column 37: syntax error at [GROUP].
Internal Exception: MissingTokenException(inserted [@-1,0:0='<missing IDENT>',<80>,1:37] at GROUP)