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

满意答案

intothewest

2013.06.09

采纳率：52%    等级：10

已帮助：2168人

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;

00分享举报