목록1179 (1)

조컴퓨터

leetcode 1179. Reformat Department Table

1) CASE WHEN 1-1) SELECT id , CASE WHEN month = "Jan" THEN revenue ELSE NULL END AS Jan_Revenue , CASE WHEN month = "Feb" THEN revenue ELSE NULL END AS Feb_Revenue , CASE WHEN month = "Mar" THEN revenue ELSE NULL END AS Mar_Revenue , CASE WHEN month = "Apr" THEN revenue ELSE NULL END AS Apr_Revenue , CASE WHEN month = "May" THEN revenue ELSE NULL END AS May_Revenue , CASE WHEN month = "Jun" THEN..
LeetCode/SQL 2021. 1. 18. 14:40
이전 Prev 1 Next 다음