아래 데이터와 SQL의 결과로 올바른 것은?
보기
[T]
| SAL |
|---|
| 1000 |
| 2000 |
| 3000 |
SELECT SAL, FIRST_VALUE(SAL) OVER (ORDER BY SAL ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS MIN_SAL FROM T;
- 11000 1000 1000
- 21000 2000 3000
- 33000 2000 1000
- 43000 3000 3000
꿈라CBT