I am struggling with a small problem. I have a table as follows
I need output as follows.
I need to get the concatenated name for a given
.I tried using concat function but i ended up empty handed.