ORA-00937: not a single-group group function说明及解决方法(E文)
来源:互联网 发布:获取东方财富k线数据 编辑:程序博客网 时间:2024/06/17 00:07
ORA-00937: not a single-group group function说明及解决方法(E文)
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://avatar.csdn.net/3/A/C/1_evilcry2012.jpg)
- ORA-00937: not a single-group group function说明及解决方法(E文)
- ORA-00937: not a single-group group function说明及解决方法(E文)
- “not a single-group group function”
- oracle报错: “not a single-group group function”
- ORA-00979: not a GROUP BY expression
- ORA-00979: not a GROUP BY expression报错处理
- [Err] ORA-00979: not a GROUP BY expression
- Structure of a Function Group
- Function Group
- HAVING Clause Without a Group Function
- System.Data.OracleClient.OracleException: ORA-00979: not a GROUP BY expression
- Access Denied: Specified user is not is not a member of TelnetClients group解决方法
- TypeError: e[h] is not a function
- e.slice is not a function
- group
- group
- Group
- Group
- php安装扩展gd报错解决
- spring—bean的作用域
- 1013. Battle Over Cities (25)
- IMAS历年真题下载(小学中高年级组2012-2016年 上海卷)
- eclipse编辑js卡死解决方案
- ORA-00937: not a single-group group function说明及解决方法(E文)
- 把三位整数由大到小输出
- 妙用WIN64AST来运行破解版的SANDBOXIE(无需打开测试签名模式)
- hadoop伪分布式安装步骤
- 搭建nginx做测试服务器
- 6.18
- 【Kafka源码】broker被选为controller之后的连锁反应
- OpenCV-Python-Tutorial[1]
- 插入排序