Question

Which is the most important benefit of window function?

(a) Aggregation

(b) Association

(c) Generalization

(d) All of the mentioned

I have been asked this question by my college director while I was bunking the class.

I'd like to ask this question from Windowing in chapter Manipulating Data with Select of SQL Server

Answer 1

Correct choice is (a) Aggregation

Best explanation: Most important benefit of window functions is that we can access the detail of the rows from an aggregation.