What is a window frame, such as ROWS BETWEEN, and why does it matter for running metrics?
PICTURE THIS: DATABASE INDEX
Simple meaning
The frame clause defines which rows in the partition participate in the window aggregate relative to the current row.
WHY — SQL Analytics instead of guessing?
Why interviewers care about SQL Analytics:
people who only read docs from people who shipped.
and tied to Data Science work.
Name the idea, why it exists, then one short example.
End with when you use it and one common pitfall.
STEPS — What happens step by step?
Before you speak the answer, walk the interviewer through these steps:
- 1The frame clause defines
which rows in the partition participate in the window aggregate relative to the current row.
- 2RANGE versus ROWS treat
ties in ORDER BY differently, which can silently expand a 'last 7 days' sum.
- 3Wrong frames turn a
seven-day rolling conversion into a cumulative lifetime sum.
- 4Give an example
One tiny concrete case you can say aloud.
- 5Common mistake
What juniors usually get wrong.
- 6Close
When you pick this over the alternative.
EXAMPLE — See it in action
Here's a short line you can speak, broken into clear beats:
Note: Adapt this scaffold to your own project — keep it under 60–90 seconds.
Key takeaway
The frame clause defines which rows in the partition participate in the window aggregate relative to the current row. RANGE versus ROWS treat ties in ORDER BY differently, which can silently expand a 'last 7 days' sum.