Do I understand correctly that the main difference between window functions and aggregate functions is that in aggregate functions the result of each group is only one row. But then what about the window?

  • one
    The windows consider the same as the aggregate, but they substitute the result in each source data line - Mike
  • one
    Well, the wording that the result of the aggregate is one line is not quite correct. the line will still be left alone, group by will try. And the aggregate function will collect the result from the source lines for this line - Mike
  • one
    Window functions in addition to a set of rows take the order and the current line. - PetSerAl

0