create table abc
(
nid varchar2(10),
aname varchar2(10),
obname varchar2(10),
money varchar2(10)
)
insert into abc (nid,aname,obname,money) values('1','aaa','x1','1111');
insert into abc (nid,aname,obname,money) values('2','bbb','x2','2222');
insert into abc (nid,aname,obname,money) values('3','ccc','x3','3333');
insert into abc (nid,aname,obname,money) values('4','ddd','x4','4444');
insert into abc (nid,aname,obname,money) values('5','eee','x1','5555');
commit;select * from abcselect nid,
sum(decode(obname,'X1',money,0)) x1,
sum(decode(obname,'X2',money,0)) x2,
sum(decode(obname,'X3',money,0)) x3,
sum(decode(obname,'X4',money,0)) x4
from abc
group by nid查询的结果是
nid x1 x2 x3 x4
1 0 0 0 0
3 0 0 0 0
5 0 0 0 0
2 0 0 0 0
4 0 0 0 0我想要的結果是
nid x1 x2 x3 x4
1 1111 0 0 0
3 0 0 3333 0
5 5555 0 0 0
2 0 2222 0 0
4 0 0 0 4444求解感謝
(
nid varchar2(10),
aname varchar2(10),
obname varchar2(10),
money varchar2(10)
)
insert into abc (nid,aname,obname,money) values('1','aaa','x1','1111');
insert into abc (nid,aname,obname,money) values('2','bbb','x2','2222');
insert into abc (nid,aname,obname,money) values('3','ccc','x3','3333');
insert into abc (nid,aname,obname,money) values('4','ddd','x4','4444');
insert into abc (nid,aname,obname,money) values('5','eee','x1','5555');
commit;select * from abcselect nid,
sum(decode(obname,'X1',money,0)) x1,
sum(decode(obname,'X2',money,0)) x2,
sum(decode(obname,'X3',money,0)) x3,
sum(decode(obname,'X4',money,0)) x4
from abc
group by nid查询的结果是
nid x1 x2 x3 x4
1 0 0 0 0
3 0 0 0 0
5 0 0 0 0
2 0 0 0 0
4 0 0 0 0我想要的結果是
nid x1 x2 x3 x4
1 1111 0 0 0
3 0 0 3333 0
5 5555 0 0 0
2 0 2222 0 0
4 0 0 0 4444求解感謝
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货