I am on 10.2.0.1 and found an very interesting implementation in oracle having row_number() analytical function optimized for Top-n-querie...