select bdz_name,
sum(y_get_sum) as y_get,
case
when sum(y_get_sum) > 0 then
Round((sum(y_get_sum) - sum(y_put_sum)) / sum(y_get_sum) * 100, 2) as
y_bph --ORA-00905: 缺少关键字
else
0
end
from mxph_line_energy
group by bdz_name, v_rank, dt_year, dt_month
having v_rank = 110 and dt_year = 2006 and dt_month = 1
order by bdz_name;
请问如何给 Round((sum(y_get_sum) - sum(y_put_sum)) / sum(y_get_sum) * 100, 2) 加个别名呀
sum(y_get_sum) as y_get,
case
when sum(y_get_sum) > 0 then
Round((sum(y_get_sum) - sum(y_put_sum)) / sum(y_get_sum) * 100, 2) as
y_bph --ORA-00905: 缺少关键字
else
0
end
from mxph_line_energy
group by bdz_name, v_rank, dt_year, dt_month
having v_rank = 110 and dt_year = 2006 and dt_month = 1
order by bdz_name;
请问如何给 Round((sum(y_get_sum) - sum(y_put_sum)) / sum(y_get_sum) * 100, 2) 加个别名呀
解决方案 »
- 几道Oracle题目,找不到答案,求正解。跪谢,全部分送上
- 救急,同志们!系统连不上中心数据库了!
- 如何在navigator 中创建匿名块?
- 一个关于大数据量取数据的问题
- 求一个8i的服务器端啊
- 为什么这条sql不走索引啊???
- 为了建立asm磁盘,是不是必须预留专门的分区啊?
- sql中删除重复的记录
- ORACLE 数据链路问题
- 请问怎样用update修改数据?
- 数据库连接串的奇怪问题(Connect Timeout一加就异常)
- 有两个表T1,T2, T1的字段(T1_K1,T1_K2,T1_K3,T1_F1,T1_F2….)T2的字段(T2_K1,T2_K2,T2_K3,T2_F1,T2_F2….)K1,K2,K3都是KEY,两个表用这两
sum(y_get_sum) as y_get,
case
when sum(y_get_sum) > 0 then
Round((sum(y_get_sum) - sum(y_put_sum)) / sum(y_get_sum) * 100, 2)
else
0
end as y_bph
from mxph_line_energy
where v_rank = 110 and dt_year = 2006 and dt_month = 1
group by bdz_name, v_rank, dt_year, dt_month
order by bdz_name;这样可能效率高点;as放 end后,或者不要as,直接中间有个空格就行。