转自：http://blog.csdn.net/xb12369/article/details/39554935
select *
from (select trunc(created_time),action_type,user_id
from t_shq_task_operate_log l
where l.created_time > trunc(sysdate - 7)
and l.created_time < trunc(sysdate)
and l.action_type in (0,1,2,3,4)) pivot(count(distinct user_id) for action_type in (0,4));
首先感谢提供Oracle的行列转换丝路！！！
原始表数据：
辅助思考：
涨姿势的关键字：pivot
-------------------------------------------------------------------------------------------------------------------------------
存储过程实现动态行转列：http://www.cnblogs.com/QQParadise/articles/1712093.html
- 顶
- 0
- 踩
