--下面语句在plsql里面是可以执行的,但是在ibatis配置文件里面却不能执行报effectuser标识符无效是什么问题,为什么不能设置别名后求和
select c.spec_name, sum(c.effectuser)
from (select b.spec_name,
b.spec_id,
a.alarmneid,
max(a.effectuser) effectuser
from ta_realalarm a, tr_net_spec b
where a.specialty = b.spec_id
and a.alarmstatus = 1
and a.effectuser > 0
group by b.spec_name, b.spec_id, a.alarmneid) c
group by spec_name
select c.spec_name, sum(c.effectuser)
from (select b.spec_name,
b.spec_id,
a.alarmneid,
max(a.effectuser) effectuser
from ta_realalarm a, tr_net_spec b
where a.specialty = b.spec_id
and a.alarmstatus = 1
and a.effectuser > 0
group by b.spec_name, b.spec_id, a.alarmneid) c
group by spec_name
可以尝试设置与列名不同的别名(可能会冲突)