SQL:行列转换
现在的结果:
想要的结果:
把现在的结果,每取4列放在一行。
select
max(case QUESTIONNO when 'TJBGSAB1' then QUESTIONANSWER end),
max(case QUESTIONNO when 'TJBGSAB2' then QUESTIONANSWER end),
max(case QUESTIONNO when 'TJBGSAB3' then QUESTIONANSWER end),
max(case QUESTIONNO when 'TJBGSAB4' then QUESTIONANSWER end)
from LCREPORTQUESTIONNAIRE
where CONTNO = '00000000001114'
and idno = '0000055911'
and QUEMODULECODE ='TJBGSA'
and QUESUBMODULECODE like 'B%'
group by QUESUBMODULECODE;