Tag: <span>windowing</span>

Have SUM() fun!

By Vedran Posted on 2020-05-26 Posted in TSQL and SQL Client Code 1 Comment Tagged with analytic, over, sql, visualization, windowing

Did you know that SUM() aggregate can be used together with OVER() clause? A short intro to windowing functions:

SELECT SUM(Amount) OVER() -- What!?
FROM dbo.PersonCityAmount

1 2	SELECT SUM(Amount) OVER() -- What!? FROM dbo.PersonCityAmount

The result is graphically visualized by using only SQL Server Management Studio and unicode characters: