フリー問題

問題文

A report needs each order row together with the running total for its customer. Which construct keeps every row?

選択肢

1. The analytic call adds the OVER clause so it keeps collapsed keys in the output, and the plain aggregate consequently returns ordered windows for each key.
2. The analytic call adds the OVER clause so it keeps individual rows in the output, and the plain aggregate consequently returns ordered windows for each key.
3. The analytic call adds the OVER clause so it keeps individual rows in the output, and the plain aggregate consequently returns grouped totals for each key.
4. The analytic call adds the OVER clause so it keeps collapsed keys in the output, and the plain aggregate consequently returns grouped totals for each key.