[mysql] 통계쿼리, WITH ROLLUP 사용하기
통계 쿼리 작성 후 각각 수를 더하는 걸 간단하게 WITH ROLLUP을 사용해서 완성하였다 SELECT IFNULL(depart_nm,'모든합계') as depart_nm, IFNULL(org_nm, '전체') as org_nm, SUM(X.JOIN_COUNT1) AS stepB, SUM(X.JOIN_COUNT2) AS stepC, SUM(X.JOIN_COUNT3) AS stepD, SUM(X.JOIN_COUNT4) AS stepE, SUM(X.JOIN_COUNT5) AS stepF, SUM(X.JOIN_COUNT6) AS stepG, SUM(X.JOIN_COUNT7) AS stepH, SUM(X.JOIN_COUNT8) AS stepI, SUM(X.JOIN_COUNT9) AS stepJ, SUM(X.J..
2022. 10. 6.
