Question

ORA-01427:单行子查询返回多于一行

(select gg_dw.dwmc from gjj_dwzz,gg_dw where gjj_dwzz.dwbh=gg_dw.dwbh) dwmc ,sum(gjj_dwzz.ye) from gjj_dwzz group by gjj_dwzz.dwbh

Answer 1

select gg_dw.dwmc,sum(gjj_dwzz.ye)
from gjj_dwzz,gg_dw where gjj_dwzz.dwbh=gg_dw.dwbh
group by gjj_dwzz.dwmc

追问

提示：不是gruop by 语句。。。

追答

select b.dwmc,sum(a.ye)
from gjj_dwzz a,gg_dw b
where a.dwbh = b.dwbh
group by b.dwmc