I have been trying it with the tables I have but getting strange result sets. Got 100968 rows of same values :P

However I think inner view method would be slower (and much) because of double checking of search criteria in the inner view and the parent query.

I still have to see why I am getting wrong result sets.

The analytic function seems much more elegant and clean compare with the one I am trying with inner views.

Thanks