$ ./guess_the_languageSQL & Databases
SQL & Databases · easy · #43

How does SUM(x) OVER (...) differ from SUM(x) with GROUP BY?

  1. It ignores NULL values
  2. It runs before WHERE
  3. It keeps every input row
  4. It only works on numbers
A window function computes across related rows but returns a value on each row instead of collapsing them.
Play SQL & Databases ▸