Oracle的行列转换

转自：http://blog.csdn.net/xb12369/article/details/39554935

尝试SQL: 统计每天每个类型操作个用多少用户

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的行列转换丝路！！！

原始表数据：

辅助思考：

1. selectusertelephone,
2. max(decode(filedid,answervalue,0))as"问题1",
3. max(decode(filedid,0))as"问题2",0))as"问题3",4,0))as"问题4",5,0))as"问题5",6,0))as"问题6",7,0))as"问题7"
4. fromt_d_Serveyanswerwhereserveyid=3groupbyusertelephoneorderby1asc;

涨姿势的关键字：pivot