Hey, sorry for the typos in my previous post. Replace the "greather than" with "less then" characters in a query and you will get the k-row sliding window result with the offset by N.

Well, even if I would have write the query correctly, this damn HTML forum software would have messed it totaly because it doesn't allow the usage of "less then" characters ... :-(