本文介绍了ORA-00979：不是GROUP BY表达式的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
我想展示学生们工作的所有不同公司。
I am trying show all the different companies for which students work. However only companies where more than four students are employed should be displayed.
这是我到目前为止：
中聚合或包含的字段$ c> clause - 在您现有的选择中，您在select子句中包括 EMPLOYER ，但不能按其分组或聚合。When grouping or including aggregated fields, your select statement should only include fields that are either aggregated or included in the group by clause - in your existing select, you are including EMPLOYER in your select clause, but not grouping by it or aggregating it.
这篇关于ORA-00979：不是GROUP BY表达式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！