Well the answers are welcome, the more the merrier, I was just not understanding why the second post of the same question. BTW - I've learned from your post that the window definition without a partition clause seems to work the same as a PARTITION BY 1 - I did not know that, so I for one am happy you had a go.