Thanks dude for your greeting and to workable solution, this solves my purpose. This is half of my entire situation i have. I will be happy if i can remove Distinct from other half situation i have. What should i do to achieve result.

I am adding case statement to earlier query we discussed. Consider this data is outcome of case added query.