The way I would do it is with partitioning and a view. Though I think you discounted this when you mentioned "materialised views", I was wondering why this is...

That gets the first record set, what about the 2nd? (I'm assuming this was the point of the question after all?)

I'm unaware of any "tidy" solution to this myself...