大家帮忙看下这个sql group by 字句报错“aa:标识符无效”应该怎么写select t.carno,
sum(decode(t.year,'2010', t.TINSURANCEPRICE,null)) as "2010",
sum(decode(t.year,'2011', t.TINSURANCEPRICE,null)) as "2011" ,
decode(t.year,'2010', t.TINSURANCEPRICE,null) as "aa"
from base_car_oninsurance t
where t.year=2011 or t.year=2010
group by t.carno,t.driver,"aa"
sum(decode(t.year,'2010', t.TINSURANCEPRICE,null)) as "2010",
sum(decode(t.year,'2011', t.TINSURANCEPRICE,null)) as "2011" ,
decode(t.year,'2010', t.TINSURANCEPRICE,null) as "aa"
from base_car_oninsurance t
where t.year=2011 or t.year=2010
group by t.carno,t.driver,"aa"
或是如下操作:
select t.carno,
sum(decode(t.year,'2010', t.TINSURANCEPRICE,null)) as "2010",
sum(decode(t.year,'2011', t.TINSURANCEPRICE,null)) as "2011" ,
decode(t.year,'2010', t.TINSURANCEPRICE,null) as "aa"
from base_car_oninsurance t
where t.year=2011 or t.year=2010
group by t.carno,t.driver,decode(t.year,'2010', t.TINSURANCEPRICE,null)
修改为 group by group by t.carno,t.driver, decode(t.year,'2010', t.TINSURANCEPRICE,null)
order by可以用别名