將下標顯示成右邊的形式，列轉行的使用。

SELECT

       name,

       MAX(

              CASE

              WHEN week='1' THEN

                     course

              END

       )as '星期一',

       MAX(

              CASE

              WHEN week='2' THEN

                     course

              END

       )as '星期二',

       MAX(

              CASE

              WHEN week='3' THEN

                     course

              END

       )as '星期三',

       MAX(

              CASE

              WHEN week='4' THEN

                     course

              END

       )as '星期四',

       MAX(

              CASE

              WHEN week='5' THEN

                     course

              END

       )as '星期五'

FROMteacher