Aquesta manera de fer la select es una alternativa al típic TRANSPOSE. Es més ràpid i més senzill de fer:
SELECT
pid,country,
COUNT(CASE WHEN quesid = '1.1' THEN ct_recid ELSE NULL END) AS Q1_1,
COUNT(CASE WHEN quesid = '1.2' THEN ct_recid ELSE NULL END) AS Q1_2,
COUNT(CASE WHEN quesid = '1.3' THEN ct_recid ELSE NULL END) AS Q1_3,
COUNT(CASE WHEN quesid = '1.4' THEN ct_recid ELSE NULL END) AS Q1_4,
COUNT(CASE WHEN quesid = '1.5' THEN ct_recid ELSE NULL END) AS Q1_5,
COUNT(CASE WHEN quesid = '1.6' THEN ct_recid ELSE NULL END) AS Q1_6,
COUNT(CASE WHEN quesid = '1.7' THEN ct_recid ELSE NULL END) AS Q1_7,
COUNT(CASE WHEN quesid = '1.8' THEN ct_recid ELSE NULL END) AS Q1_8,
COUNT(CASE WHEN quesid = '2.1' THEN ct_recid ELSE NULL END) AS Q2_1,
COUNT(CASE WHEN quesid = '2.2' THEN ct_recid ELSE NULL END) AS Q2_2,
COUNT(*) AS total
FROM
lAS34273_30.INCLUSION_DATA
GROUP BY
pid, country
Alternativa a Transpose
