🧠 What Are SQL Window Functions? A Beginner’s Guide to OVER()

Xorthax the Merchant needed a way to analyze his trading data without losing detail. He didn’t want a single total—he wanted insight on every row. That’s what SQL window functions do.

🚀 Window Functions and OVER()

A window function performs a calculation across a set of rows and returns a result for each row.

Every window function uses the OVER() clause:

FUNCTION(...) OVER ()

At its simplest, this means:

• The function looks across multiple rows
• The result is added to every row

You can think of OVER() as defining the group of rows the function can “see.”

📊 Example: Using SUM() OVER()

🧾 Sample Data

SELECT OrderID, Amount,
       SUM(Amount) OVER () AS TotalAmount
FROM Orders;

Result:

The total (600) is calculated across all rows and shown on every row.

🧠 What’s Happening Here?

SUM(Amount) calculates a total across the dataset, and OVER() tells SQL:

• Don’t collapse the rows like group by does
• Attach the result to each row instead

That’s the foundation of all window functions.

🧪 Practice What You Just Learned

SELECT orderid, totalamount, SUM(totalamount) OVER () AS total_revenue FROM orders ORDER BY orderid;