Please don't post the same the same message over and over. If you don't like the answer in your earlier thread,
then post a reply in that thread, with some additional value (such as a clarification of what you want). Posting the exact same message won't get any better answers.
This is different question as can use either analytic function or outer-join to achieve our result.
This concerns specfically performance of outer join versus analytic function i..e performance-related query hence though best to have new thread
However, will post in the other thread.