oracle中报错不是单组分组函数怎么解决

oracle中报错不是单组分组函数怎么解决

oracle中报不是单组分组函数一般是group by语法错误。
如emp表中有如下数据：
先要求求每个deptno下sal的总和是多少，错误语句如下：
select deptno,sum(sal) from emp;报错如图：

解决方法：需要将语句中的非聚合函数部分写到group by中，最后语句为：
select deptno,sum(sal) from emp group by deptno;最终正确结果如图：

2017-06-26

select p.requi_form,
sum(decode(p.requi_form, '0', r.bid_amount, 0)) a,
sum(decode(p.requi_form, '1', r.bid_amount, 0)) b,
sum(decode(p.requi_form, '2', r.bid_amount, 0)) c,
sum(decode(p.requi_form, '3', r.bid_amount, 0)) d,
sum(decode(p.requi_form, '4', r.bid_amount, 0)) e,
sum(p.bid_amount) 采购金额,
sum(r.bid_amount) 招标采购金额,
sum(r.bid_amount) / sum(p.bid_amount) 招标采购率
from cg_purchase_project p,
cg_purchase_report r
where r.purc_pro_id = p.purc_pro_id
and p.purc_pro_state != 11
group by p.requi_form
order by p.bid_team;2013-08-28

在group by 后面加一个p.bid_team2013-08-30

group by 后面加上 p.requi_form2013-08-28