Hi, Chris et al

I agree with one of your post when you sugested not to post the same question to two different forums. It realy is confusing.

About your solution - I agree it is more efficient in some rare situations. However in a real life requirenments, when sliding window mechanism has to be applied to a *sorted* total resultset your solution is wrong because ROWNUM and ORDER BY in the same selct doesn't work as one could expect (and I know you are perfectly aware of that, it must just have slipped your mind). I'll explain what I mean in more detaile in Administartion forum under your solution.