我从一个简单的查询中得到了此消息(CANNOT_GROUP_WITHOUT_AGG) [英] I got this message (CANNOT_GROUP_WITHOUT_AGG) from a simple query

问题描述

我该如何解决此错误消息?

I how to fix this error message?

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

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)

推荐答案

如果您没有汇总功能(例如SELECT中的sum，avg，count)，则没有任何用处对于GROUP BY-您可以将其删除. 如果要显示唯一记录，请使用distinct.

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.

这篇关于我从一个简单的查询中得到了此消息(CANNOT_GROUP_WITHOUT_AGG)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！