I got this message (CANNOT_GROUP_WITHOUT_AGG) from

问题:

I how to fix this error message?

Unable to parse query string for Function QUERY parameter 2: CANNOT_GROUP_WITHOUT_AGG

I got that error message just from a simple query formula, I already tried to search about it and try with the curly bracket { ... } but it doesn't fixed, Can anyone help me or ever experienced it?

=QUERY(ANSWER!C:C, "SELECT * GROUP BY C", 0)

回答1:

If you don't have an agreggation function (such as sum, avg, count in SELECT), there is no use for GROUP BY - you may just delete it. If you wish to present unique records, use distinct instead.