Doubt in select with group by and Count?

Question

I’m making a SQL in 2 tables in Oracle and would like to group the information according to the job code and also count how many people are in that position.

I’m using the following SQL:

select f.numemp, f.numcad, f.nomfun, f.codcar, c.titcar, count(*) from R034fun f
join R024car c
on f.codcar = c.codcar
where f.codcar in ('0001157','800739','800852') and f.sitafa <> 7 
group by f.codcar

But I get the following error:

ORA-00979: não é uma expressão GROUP BY 00979. 00000 - "not a GROUP BY expression" Cause:Action: Erro na linha: 1 Coluna: 8

Can someone help me by telling me what’s wrong with my code?

Answer 1

Oracle "group by" has to be the same as "select"

select f.numemp, f.numcad, f.nomfun, f.codcar, c.titcar, count(*) from R034fun f
join R024car c
on f.codcar = c.codcar
where f.codcar in ('0001157','800739','800852') and f.sitafa <> 7 
group by f.numemp, f.numcad, f.nomfun, f.codcar, c.titcar