実際の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
![グループ抽出した複数行を1行にまとめるSQL | MiYABiS note.](https://cdn-ak-scissors.b.st-hatena.com/image/square/ca08c769d0e7a9e33ec0abdbeb6a5054759e2f59/height=288;version=1;width=512/https%3A%2F%2Fnote.miyabis.jp%2Fwp-content%2Fuploads%2F2018%2F08%2FShortcutIcon.png)