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) 加个别名呀
解决方案 »
- 日期计算问题
- 求一条sql语句!统计的
- oracle聚合函数使用问题!急
- 火烧眉毛+十万火急~~~ ORA-03114: not connected to ORACLE
- 怎么删除全部记录的一个字段值呢?
- Oracle sql语句
- 用SYS_GUID做为默认值,不可以么?
- 我想在oracle的一个字段中插入有换行内容的字符串,如何实现?
- 怎样在一台机器的listener.ora中配置多个listener????
- 菜鸟问题!权限不足的问题
- 数据库连接串的奇怪问题(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,直接中间有个空格就行。