http://www.sqlservercentral.com/blogs/sql_awesomesauce/2012/11/26/tip-over-and-partition-by/

Printed 2014/12/22 02:26AM

Tip: OVER and PARTITION BY

By Jen McCown, 2012/11/26

I like to repost this blog about once a ¬†year, because you really really need to know about windowing functions. So, happy November! Here’s a quick summary of OVER and PARTITION BY (windowing functions, “new” in SQL 2005), for the uninitiated or forgetful… OVER OVER allows you to get aggregate ...
Copyright © 2002-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.