-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|