여러 칼럼들 중 최대값 구하기

SELECT CODE, NAME, NULL,

           MAX(CASE WHEN [E01] > [E02] THEN '02'

                           WHEN [E01] < [E02] THEN '01'

                            ELSE '99' END),

           MAX(CASE WHEN [D01] > [D02] AND [D01] > [D03] AND [D01] > [D04] AND [D01] > [D05] AND [D01] > [D06] THEN '01'

                           WHEN [D02] > [D03] AND [D02] > [D04] AND [D02] > [D05] AND [D02] > [D06] THEN '02'

                           WHEN [D03] > [D04] AND [D03] > [D05] AND [D03] > [D06] THEN '03'

                           WHEN [D04] > [D05] AND [D04] > [D06] THEN '04'

                           WHEN [D05] > [D06] THEN '05'

                           ELSE '06' END) , 'N', '','','import', getdate(), 'import', getdate()

FROM [MetaSyn].[dbo].[40Fdata]

GROUP BY CODE, NAME

HAVING NAME IS NOT NULL