首先感谢提供Oracle的行列转换丝路!!!
原始表数据:
辅助思考:
select usertelephone,
max(decode(filedid, 1, answervalue, 0)) as "问题1",
max(decode(filedid, 2, answervalue, 0)) as "问题2",
max(decode(filedid, 3, answervalue, 0)) as "问题3",
max(decode(filedid, 4, answervalue, 0)) as "问题4",
max(decode(filedid, 5, answervalue, 0)) as "问题5",
max(decode(filedid, 6, answervalue, 0)) as "问题6",
max(decode(filedid, 7, answervalue, 0)) as "问题7"
from t_d_Serveyanswer where......
阅读全文