MySQLで縦に表示を横に表示する場合ですが、下記のような例がありました。 この例だとCASEの数が４なのでいいですが、もっとある場合、WhileとかForeachのような構文はありますか？ SELECT SALES_YEAR, SUM(CASE QUARTER_NO WHEN 1 THEN SALES_AMOUNT ELSE 0 END) AS SELES_AMOUNT_1, SUM(CASE QUARTER_NO WHEN 2 THEN SALES_AMOUNT ELSE 0 END) AS SELES_AMOUNT_2, SUM(CASE QUARTER_NO WHEN 3 THEN SALES_AMOUNT ELSE 0 END) AS SELES_AMOUNT_3, SUM(CASE QUARTER_NO WHEN 4 THEN SALES_AMOUNT ELSE 0 END) AS SELES_AMOUNT_4, SUM(SALES_AMOUNT) AS SELES_AMOUNT_TOTAL FROM QUARTERLY_SALES foreach($array = $ct){ SUM(CASE QUARTER_NO WHEN ($ct) THEN SALES_AMOUNT ELSE 0 END) AS SELES_AMOUNT_1} こんな感じです。