查询不接受GROUP BY [英] Query not accepting GROUP BY

问题描述

我在这里有一个没有GROUP BY子句的查询

展开 | 选择 | Wrap < span class =codeDivider> | 行号

解决方案

< blockquote>尝试这个......

展开 | 选择 | Wrap | 行号

仍然有无效的过程调用 ...是因为源是查询，所以分组有一些限制吗？

我对此表示怀疑。我猜它更多地与SC字段的长度有关。只有其他选项是在没有group by的情况下运行查询，然后使用group by运行第二个查询。


首先尝试另外一个，将SC字段放在括号中如下：

展开 | 选择 | Wrap | < span class =codeLinkonclick =LineNumbers（this）;>行号

I have a query here which works without the GROUP BY clause

Expand|Select|Wrap|Line Numbers

解决方案

Try this ...

Expand|Select|Wrap|Line Numbers

Still having the Invalid procedure call...is it because the source is a query, so there''s some limitations to the groupings?

I doubt it. I would guess it has more to do with the length of the SC field. Only other option is to run the query without the group by and then run a second query off it with a group by.

Try one other thing first, put the SC field in brackets as follows:

Expand|Select|Wrap|Line Numbers

这篇关于查询不接受GROUP BY的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！