자답입니다.

SELECT mdate

        , MIN( CASE rn WHEN 1 THEN mgm   END) As mgm1

        , MIN( CASE rn WHEN 1 THEN jumsu END) As jumsu1

        , MIN( CASE rn WHEN 2 THEN mgm   END) As mgm2

        , MIN( CASE rn WHEN 2 THEN jumsu END) As jumsu2

        , MIN( CASE rn WHEN 3 THEN mgm   END) As mgm3

        , MIN( CASE rn WHEN 3 THEN jumsu END) As jumsu3

        , MIN( CASE rn WHEN 4 THEN mgm   END) As mgm4

        , MIN( CASE rn WHEN 4 THEN jumsu END) As jumsu4

        , MIN( CASE rn WHEN 5 THEN mgm   END) As mgm5

        , MIN( CASE rn WHEN 5 THEN jumsu END) As jumsu5

FROM (

    Select b.mdate,

            b.mgm,

            Max( a.jumsu ) As jumsu,

            ROW_NUMBER() OVER(PARTITION BY b.mdate ORDER BY b.mdate, b.mgm) rn

    From mogosa_dapin a Left Outer Join mogosa_deung b On b.code = a.code

    Where a.stu_c = 10014081

    Group By b.mdate, b.mgm

    Order By b.mdate Desc, b.mgm

) a

GROUP BY mdate

ORDER BY mdate Desc, Max( mgm )