Clever Geek Handbook

I got this message (CANNOT_GROUP_WITHOUT_AGG) from a simple request

How do I fix this error message?

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

I only got an error from a simple query formula, I already tried to find it and try with curly brace { ... }

but it is not fixed, Can anyone help me or ever try this out?

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


source to share


1 answer


If you do not have aggregate functions (for example sum

, avg

, count

in SELECT

) to GROUP BY

use is not necessary - you can just delete it. If you want to represent unique records, use distinct

.



+2


source






More articles:


All Articles