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

原始表数据：

辅助思考：

selectusertelephone,

max(decode(filedid,answervalue,0))as"问题1",

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"

fromt_d_Serveyanswerwhereserveyid=3groupbyusertelephoneorderby1asc;

涨姿势的关键字：pivot

-------------------------------------------------------------------------------------------------------------------------------