프로그래머스 SQL 모음
SELECT empno , ename , job , sal , SUM(sal) OVER(ORDER BY empno) AS sum_sal FROM emp WHERE job IN ('MANAGER', 'SALESMAN') 직업별 구분없이 누적합 구할때 그냥 sum over order by 사용하면됨. 만약 직업별 구분있게 누적합을 구하고 싶다면 sum over partition by 직업 order by ~ 하면됨. SELECT empno , ename , job , sal , SUM(sal) OVER(PARTITION BY job ORDER BY empno) AS sum_sal FROM emp WHERE job IN ('MANAGER', 'SALESMAN&..
2024. 2. 25.