This video shows a very simple example of the Windows Function using the COUNT aggregate. I attempt to illustrate with this example how you can combine different granular aggregates on the same detail rows of a single output result. This example only scratches the surface of the beauty of the Windows Function. Its elegant, versatile and powerful (just like a fancy sport car, but no extra cost) and yet many veteran sql developers never have used it. It makes the Group By Clause almost extinct. Talk to someone who has just discovered the Windows Function, and you will usually find someone who will tell you how great it is, but not always able to give examples off the top of their head on why.

( www.linkedin.com/in/greg-c-coopman-b07b54103/ )