Most Confusing SQL Window Function Explained (ROWS vs RANGE)
In this video, I explain SQL Window Aggregate Functions in a clear, interview-oriented way, focusing on SUM() OVER() and running total logic.
We start directly in the SQL editor, understand how window functions work, and then dive into one of the most confusing interview topics:
✔ Running Total
✔ Grand Total
✔ ROWS vs RANGE
✔ UNBOUNDED PRECEDING
✔ CURRENT ROW
✔ FOLLOWING
✔ Handling duplicate values
✔ Running total starting from 2nd row
Many candidates memorize syntax but fail in interviews because they don’t understand how SQL thinks internally.
This video explains the logic behind window frames, not just the syntax.
🔥 Important:
This exact ROWS vs RANGE running total problem was asked in an HCL SQL interview, and most candidates failed.
If you are preparing for:
SQL Interviews
Data Analyst / BI roles
Advanced SQL concepts
Window functions with real-world logic
👉 This video is for you.
⏱ Topics Covered:
SQL Window Aggregate Functions
SUM() OVER explained
Running Total in SQL
ROWS vs RANGE difference
UNBOUNDED PRECEDING explained
CURRENT ROW explained
FOLLOWING explained
Running total from 2nd row
Interview traps & tips
👍 Like | 💬 Comment | 🔔 Subscribe
for more interview-focused SQL content.
sql window functions
sql running total
rows vs range sql
sql interview questions
window functions in sql
sql sum over
sql analytical functions
sql interview preparation
data analyst sql interview
sql for data analyst
advanced sql
hcl sql interview question
sql running total from second row
unbounded preceding sql
sql window frame
sql rows between
sql range between
sql tutorial interview
sql real interview question