palotaiarpad (4/27/2015)
Link is already in my first post, but please: https://msdn.microsoft.com/en-us/library/ms187810.aspx
BOL is incorrect. At the bottom, there are already 2 remarks stating the same.
If you take a look at the OVER clause page where BOL links to, you can see it is explicitly stated that ORDER BY is not required.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP