当前位置: 代码迷 >> Web前端 >> ORA-00937: not a single-group group function说明及解决办法
  详细解决方案

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

热度:1173   发布时间:2012-11-10 10:48:51.0
ORA-00937: not a single-group group function说明及解决方法

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


本文来自CSDN博客,转载请标明出处:http://blog.csdn.net/smh821025/archive/2009/03/15/3992763.aspx

  相关解决方案