oracle如何统计一行数据和

[筱妺]

select app_work_type,
sum(case
when app_level = '0' then
1
else
0
end) as a,
sum(case
when app_level = '1' then
1
else
0
end) as b,
sum(case
when app_level = '2' then
1
else
0
end) as c,
sum(case
when app_level = '3' then
1
else
0
end) as d,
sum(a+b+c+d)as total
from t_authenticate_reg
group by app_work_type;
为什么会有标识符无效，就是那个‘d’

[CT_LXL]

引用 楼主 YXyangxian 的回复:

select app_work_type, sum(case when app_level = '0' then 1 else 0 end) as a, sum(case when app_level = '1' then 1 else 0 end) as b, sum(case when app_level = '2' then 1 else 0 end) as c, sum(case when app_level = '3' then 1 else 0 end) as d, sum(a+b+c+d)as total from t_authenticate_reg group by app_work_type; 为什么会有标识符无效，就是那个‘d’

在同一层次里，不能用别名

[筱妺]

那要怎么改呀，我才接触Oracle，请您指教一下，好吗？