oracle 分组的问题

显示全部楼层 · 2010-7-2 12:50:15

select chedui,xianlu,sum(youhao) from tbl group by chedui,xianlu
由于chedui列的数据可能为空得到的分组数据如下
cheduixianlu sum(youhao)

001
1111

002
1111
1车队 001
11111
2车队 002
11111
问题是有没有可能把第一条和第二条数据合并到相应的数据类里面呢

千问 · 2010-7-2 12:50:15

select max(chedui),xianlu,sum(youhao)from(select chedui,xianlu,sum(youhao) as youhaofrom tbl group by chedui,xianluwhere cheduiis not nullunion select chedui,xianlu,sum(youhao)as youhaofrom tbl group by chedui,xianluwhere cheduiis null)agroup by xianlu

千问 · 2010-7-2 12:50:15

select chedui,xianlu,sum(youhao) from tbl group by chedui,xianluwhere chedui is not nullunion select chedui,wmsys.wm_concat(xianlu),sum(youhao) from tbl group by chedui