select prod_id as xh,access_number as lx,count(prod_id) as cs from jd_jj_l@ab where 1=1 group by prod_id Microsoft OLE DB Provider for ODBC Drivers 错误 '80004005' [Microsoft][ODBC driver for Oracle][Oracle]ORA-00979: 不是 GROUP BY 表达式 加上where条件就报这个错误,取消where条件,运行正常
解决方案 »
- oracle 10G 数据缓冲区命中率很低
- 新手求助:VC中读取Oracle数据库的值
- oracle11的客户端,developer导出备份时的导出可执行文件是哪个?
- IMPDP导入数据问题
- sql编写,难道没有人会????
- 修改数据库中的字段
- 诸如select xx from tablename where cor in (;something) 中的something怎么变量绑定
- 请教,用oracle一句sql文完成下面功能
- 我又要请教高手
- vs2010在win7 64位环境下通过OCCI访问Oracle总是出错,怎么办?
- 求助!我遇到了一个非常诡异的问题!!
- ASP+ORACLE 移植问题,Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
select prod_id as xh,access_number as lx,count(prod_id) as cs
from jd_jj_l@ab
where 1=1
group by prod_id,access_number
------------------------------------------------------------------
ORACLE DBA的QQ群:9610122 (欢迎加入!)
不能存在列,即不在聚合函数中,也不在group by 子句中(如你的access_number列)
修正:SELECT prod_id AS xh,access_number AS lx,COUNT(prod_id) AS CS
FROM jd_jj_l@ab
WHERE 1=1
GROUP BY prod_id, access_number;