Window functions vs GROUP BY

Possible Answers

• Unlike GROUP BY results, window functions don't reduce the number of rows in the output.
  press1
• Window functions can fetch values from other rows into the table, whereas GROUP BY functions cannot.
  press2
• Window functions can open a "window" to another table, whereas GROUP BY functions cannot.
  press3
• Window functions can calculate running totals and moving averages, whereas GROUP BY functions cannot.
  press4