ORA-00937: not a single-group group function说明及解决方法

最新推荐文章于 2020-07-31 10:51:29 发布

live123

最新推荐文章于 2020-07-31 10:51:29 发布

阅读量847

点赞数

分类专栏： j2ee 文章标签： SQL .net Blog

本文链接：https://blog.youkuaiyun.com/live123/article/details/83700397

版权

j2ee 专栏收录该内容

15 篇文章

订阅专栏

本文介绍了在SQL中正确使用分组函数（如COUNT等）的方法。当查询语句包含分组函数和单独的列表达式时，必须使用GROUP BY子句来确保每个列出的单独列表达式都被包括在内，否则将导致ORA-00937错误。通过示例说明了如何避免这一错误。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

A SELECT list cannot include both a group function, such as AVG, COUNT, MAX, MIN, SUM, STDDEV, or VARIANCE, and an individual column expression, unless the individual column expression is included in a GROUP BY clause.

Drop either the group function or the individual column expression from the SELECT list or add a GROUP BY clause that includes all individual column expressions listed.

eg:

SQL> select owner, count(*)
2 from dba_segments;
select owner, count(*)
*
ERROR at line 1:
ORA-00937: not a single-group group function

Because we have a group function (COUNT) in our column list, and an additional column (OWNER), we have to include the GROUP BY clause in our select statement.

SQL> select owner, count(*)
2 from dba_segments
3 group by owner;

OWNER                            COUNT(*)
------------------------------ ----------
USER1                              166
USER2                              166

本文来自优快云博客，转载请标明出处：http://blog.youkuaiyun.com/smh821025/archive/2009/03/15/3992763.aspx