解决方案 »
- 安装ORACLE客户端后没有SQLLDR命令
- 欢迎试用:OraSQL
- power designer的简单问题
- 如果某表不存在的话创建表,存在的话做更新请问应该如何写
- DEVELOPER 2000中的POST COMMAND的功能是什么?
- IMP-00008是什么错误?从别的机器上导出的数据在另外的机器上会出现上述错误。
- Management Server 启动不了
- 关于procedure or function 返回的记录集不能select的问题!!!
- 求帮忙! 怎么把cgjg 查出来的 小于0的数据改为 0,其他的不变。 case when 或者 decode.
- 求出某月中签到最多一天的次数
- executeBatch() 事务 批量执行sql
- SQL列索引无效问题 求助
biz_tag1 biz_tag2 biz_tag3
不是汇总值哦
(
select '2011-08-22' as date_id, 'tag1' as biz_tag from dual
union all
select '2011-08-22' as date_id, 'tag2' as biz_tag from dual
union all
select '2011-08-22' as date_id, 'tag3' as biz_tag from dual
)
select tab1.date_id,
replace(wmsys.wm_concat(case when tab1.biz_tag = 'tag1' then tab1.biz_tag else '' end), ',' , '') as biz_tag1,
replace(wmsys.wm_concat(case when tab1.biz_tag = 'tag2' then tab1.biz_tag else '' end), ',' , '') as biz_tag2,
replace(wmsys.wm_concat(case when tab1.biz_tag = 'tag3' then tab1.biz_tag else '' end), ',' , '') as biz_tag3
from (select date_id, biz_tag from t group by date_id, biz_tag) tab1
group by tab1.date_id;
DATE_ID BIZ_TAG1 BIZ_TAG2 BIZ_TAG3
---------- --------- --------- --------
2011-08-22 tag1 tag2 tag3
2011-08-22 tag1 tag2 tag3
select date_id,
sum(decode(biz_tag,tag1,null)) biz_tag1 ,
sum(decode(biz_tag,tag2,null)) biz_tag2,
sum(decode(biz_tag,tag3,null)) biz_tag3
from tb
group by date_id
(
select '2011-08-22' as date_id, 'tag1' as biz_tag from dual
union all
select '2011-08-22' as date_id, 'tag2' as biz_tag from dual
union all
select '2011-08-22' as date_id, 'tag3' as biz_tag from dual
)
SELECT date_id,
MAX(decode(biz_tag,'tag1','tag1','')) biz_tag1,
MAX(decode(biz_tag,'tag2','tag2','')) biz_tag2,
MAX(decode(biz_tag,'tag3','tag3','')) biz_tag3 FROM t
GROUP BY date_id
推荐参考:http://topic.csdn.net/u/20100109/13/6a10c168-f190-4766-b838-adbf03c4ac7b.html?93286