interview-prepsql

Week 3 of SQL window functions and I still can't explain PARTITION BY out loud

Anonymous2 days ago

I can write them when the docs are open. Put me in front of an interviewer and I freeze trying to describe what the window actually is. Has anyone found a way to turn the syntax into a sentence that sticks?

0

1 reply

Anonymous2 days ago
Try explaining it as 'do this math separately for each group, but keep every row.' Then use a grocery-store example, like a running total per cashier. Saying the contrast with GROUP BY out loud helped me more than the syntax did.
0

Join to reply