T-SQL by Example

🚧 Window Aggregates

🚧 Coming soon: Cumulative sums and windowed metrics for analytics.

-- Placeholder example
SELECT OrderDate,
       SUM(TotalDue) OVER (ORDER BY OrderDate ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS RunningRevenue
FROM dbo.Sales;