1.

Which is the most important benefit of window function?(a) Aggregation(b) Association(c) Generalization(d) All of the mentionedI 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» 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.


Discussion

No Comment Found

Related InterviewSolutions