꿈라CBT아래 쿼리의 ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW 절과 동등한 의미를 가진 절은?
보기
SELECT SAL, SUM(SAL) OVER (ORDER BY SAL ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS 누적합계 FROM EMP;
- 1ROWS UNBOUNDED PRECEDING
- 2ROWS BETWEEN UNBOUNDED PRECEDING AND 1 PRECEDING
- 3RANGE UNBOUNDED PRECEDING
- 4RANGE BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING