i'm using this instruction :

select codigo,sum(vent) from exame group by codigo

and appear this message: "There is an error in the GROUP BY clause."


How can i solve this ?