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
解决方案 »
- oracle拷贝文件问题
- 如何将表中截止2011-9的数据取出来
- 关于查询中的时间函数TO_date OR TO_char
- 游标的效率问题
- 【急】怎么用10g客户端导服务器上9i的数据库?
- oracle中=>是什么含义?
- oracle,data mining,data miner连接时报错:Specified schema is not configured for use with Oracle Data Mining
- oracle速度变慢,急!!
- odbc连接oracle问题
- 请问这段简单的sql代码为什么不能继续执行完
- ■如果生成一个很长的过程,脚本已经写好了,不用可视化工具。
- 打开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