All Forums General
Overseer10 1 post Joined 07/11
14 Jul 2011
Teradata Error 3504


I have an issue regarding a group by for my query: Error 3540

I understand what it means on a basic level and I believe the issue revolves around this particular column

CAST((COALESCE(price, 0.000000)) AS DECIMAL(18,6)) * quantity amount

if I put amount in the group by it says that it cannot group by with aggregates but if I take it out it outputs error 3504

Any help?

Glass 225 posts Joined 04/10
15 Jul 2011

If you haven't already resolve this, post your query.

You must sign in to leave a comment.