Intermediate
Big Data & Data Engineering
Q50 / 100
What does a SQL "window function" allow you to do that a normal aggregate (GROUP BY) does not?
Correct! Well done.
Incorrect.
The correct answer is A) Compute aggregates across a set of rows related to the current row while still returning one row per input row
A
Correct Answer
Compute aggregates across a set of rows related to the current row while still returning one row per input row
Explanation
Window functions (e.g., ROW_NUMBER, RANK, running totals with OVER) compute values across a "window" of rows without collapsing the result like GROUP BY does.
Progress
50/100