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