![](//teradataforum.com/imgs/ptdfw1.gif) |
![](//teradataforum.com/imgs/ptdfw2.gif) |
Archives of the TeradataForum
Message Posted: Wed, 06 Apr 2005 @ 11:21:43 GMT
Subj: | | Re: 3504: selected non-aggregate values must be part of the associated group |
|
From: | | ravivijay.kumar |
Krishna Karra wrote:
| Can someone tell me what am I doing wrong in the SQL below, and the error that I am getting when I run this sql is "3504:selected no-
aggregate values must be part of the associated group" | |
Krishna,
All columns which you are selecting and not used in aggregate functions like sum,avg.. Must be mentioned in group by
Here you have only mentioned one column in group by mention other which you are selecting and not using any functions.
Thanks,
Vijay.
| |