Excellent Article! Thanks for posting this. We always find a way to query what we need.

This will allow ( for me at least ) to be a bit more surgical. I use row_number() frequently but

was unaware of all the other uses for OVER as well as ROWS & RANGE. Moving forward, I know this will cut down on the lines of code needed... replacing sub queries or CTE's I'd previously use to get different aggregate values.

Thanks again,

Bob.