グループ抽出した複数行を１行にまとめるSQL | MiYABiS note.

実際のSELECT文は下記のような感じかと。 SELECT T.Type , MAX(CASE WHEN CNT=1 THEN T.Name END) AS Name1 , MAX(CASE WHEN CNT=1 THEN T.Value END) AS Value1 , MAX(CASE WHEN CNT=2 THEN T.Name END) AS Name2 , MAX(CASE WHEN CNT=2 THEN T.Value END) AS Value2 , MAX(CASE WHEN CNT=3 THEN T.Name END) AS Name3 , MAX(CASE WHEN CNT=3 THEN T.Value END) AS Value3 FROM ( SELECT A.Type , A.Name , A.Value , COUNT(B.ID) AS CNT FROM Tes