select
time,
id_1,
name,
sum(decode(id_2,'1000',value,0)) as 值1,
sum(decode(id_2,'1001',value,0)) as 值2
from
table_a
group by
time,id_1,name
time,
id_1,
name,
sum(decode(id_2,'1000',value,0)) as 值1,
sum(decode(id_2,'1001',value,0)) as 值2
from
table_a
group by
time,id_1,name
解决方案 »
- 关于存储过程中的dblink
- 存储扩容oracle数据库迁移请教
- 局域网连接oracle
- 如何用c++.net连接oracle!!!!!谢谢,请大家指教!!!
- 关于Proc中动态SQL语句的PREPARE问题 --解决办法
- oracle8.16安装完成以后如何配置,分不够可以再加,急!
- 请问有谁知道toad的注册码码?
- 关于SQL*PLUS的运行出错
- 关于rowtype定义的问题,给高分。
- java调用oracle function 传入字符串数组 但在function中数组内容没得到,求大神指点!在线等!!!
- ■如果生成一个很长的过程,脚本已经写好了,不用可视化工具。
- 打开sql*plus时,用户名,密码,主机字符串如何填?
from table_a
group by time,id_1,name
time(date) id_1 name value value12005-03-01 12:03:03 157 aaaa 0 0
2005-03-01 12:03:03 157 aaaa 0 0
我的表是这样的:
time(date) id_1 id_2 name value2005-03-01 12:03:03 157 1000 aaaa 546
2005-03-01 12:03:03 157 1001 aaaa 507
2005-03-01 12:07:05 157 1000 aaaa 5446
2005-03-01 12:07:05 157 1001 aaaa 5037
2005-03-01 12:03:03 157 1000 bbbb 54d6
2005-03-01 12:03:03 157 1001 bbbb 50d7
2005-03-01 12:07:05 157 1000 bbbb 54d46
2005-03-01 12:07:05 157 1001 bbbb 50d37
54d6,54d46
这样的数据都存在,你怎么去做sum?我用number数据试了,结果是正确的
你看看你的value值吧
2005-03-01 08:00:00 10 60 aaaaaa 1000 468758927
2005-03-01 08:00:00 10 60 aaaaaa 1001 194179575
2005-03-01 08:15:00 10 60 aaaaaa 1000 477520148
2005-03-01 08:15:00 10 60 aaaaaa 1001 190481540
2005-03-01 08:30:00 10 60 aaaaaa 1000 507477259
2005-03-01 08:30:00 10 60 aaaaaa 1001 197720836
2005-03-01 08:45:00 10 60 aaaaaa 1000 546988957
2005-03-01 08:45:00 10 60 aaaaaa 1001 212916970
2005-03-01 08:00:00 10 60 bbbbbb 1000 468758927
2005-03-01 08:00:00 10 60 bbbbbb 1001 194179575
2005-03-01 08:15:00 10 60 bbbbbb 1000 477520148
2005-03-01 08:15:00 10 60 bbbbbb 1001 190481540
2005-03-01 08:30:00 10 60 bbbbbb 1000 507477259
2005-03-01 08:30:00 10 60 bbbbbb 1001 197720836
2005-03-01 08:45:00 10 60 bbbbbb 1000 546988957
2005-03-01 08:45:00 10 60 bbbbbb 1001 212916970
select time,id_1,id_2,name,
sum(decode(id_3,'1000',value,0))as value1,
sum(decode(id_3,'1001',value,0))as value2
from table_a
group by time,id_1,id_2,name这语句对不对?
sum(decode(id_3,'1000',value,0)) value1,
sum(decode(id_3,'1001',value,0)) value2
from table_a
group by time,id_1,id_2,name