Famous Failed [3504: HY000] Selected non-aggregate values must be part of the associated group

Database
Enthusiast

Famous Failed [3504: HY000] Selected non-aggregate values must be part of the associated group

Posting text removed based on formal request from Owner of the associated Intelectual Property.

2 REPLIES
Enthusiast

Re: Famous Failed [3504: HY000] Selected non-aggregate values must be part of the associated group

Well, The first thing is you are not using any aggregate function in the select, in the abscence of aggregation when you use the group by clause you must include all the selected columns in the group by clause, and then you can add other columns as you have added above. 

Khurram
Enthusiast

Re: Famous Failed [3504: HY000] Selected non-aggregate values must be part of the associated group

For some reason I was thinking EXTRACT was considered an aggregate.  Thank you for your help!