지난달 (1) 썸네일형 리스트형 증감률(성장률) 계산하기 - LAG OVER 참고 ) https://yahwang.github.io/posts/74 SELECT A.MONTH , A.TOTAL_SALES , CASE WHEN A.GROWTH_RATE 0 THEN ROUND(A.GROWTH_RATE, 2) || '%' ELSE '-' END AS GR_RATE FROM ( WITH MONTH_SUMMARY AS ( SELECT EXTRACT(MONTH FROM DT) AS MONTH, SUM(SALES) AS TOTAL_SALES FROM SAMPLE GROUP BY EXTRACT(MONTH FROM DT) ) SELECT MONTH, TOTAL_SALES, 100 * (TOTAL_SALES - LAG(TOTAL_SALES,1) OVER (ORDER BY MONTH)) / LAG(.. 이전 1 다음