SQL 문제 36 - Reformat Department Table LeetCode 1179

SQL 문제 36 - Reformat Department Table LeetCode 1179 Reformat Department Table 풀이 - ORACLE SELECT * FROM DEPARTMENT PIVOT( SUM(REVENUE) FOR MONTH IN ( 'Jan' JAN_REVENUE, 'Feb' FEB_REVENUE, 'Mar' MAR_REVENUE, 'Apr' APR_REVENUE, 'May' MAY_REVENUE, 'Jun' JUN_REVENUE, 'Jul' JUL_REVENUE, 'Aug' AUG_REVENUE, 'Sep' SEP_REVENUE, 'Oct' OCT_REVENUE, 'Nov' NOV_REVENUE, 'Dec' DEC_REVENUE ) ); - MYSQL SELECT ID , SUM(IF(MONTH = 'Jan', REVENUE, NULL)) AS JAN_REVENUE , SUM(IF(MONTH = 'Feb', REVENUE, NULL)) AS FE...

#ReformatDepartmentTable_LeetCode1179 #SQL #SQL_LeetCode1179 #SQL_ReformatDepartmentTable #SQL_ReformatDepartmentTable_LeetCode1179

원문링크 : SQL 문제 36 - Reformat Department Table LeetCode 1179