Question
What does PARTITION BY do inside a window function?
Select an option. Your answer will be checked instantly.
Correct Answer: C. Divides rows into independent groups while retaining individual rows
Explanation:
Window partitions define the peer group over which a calculation operates.
Unlike GROUP BY, window functions preserve row-level output.
Leave a Reply