Thanks a ton, it worked great ! I marked this as the answer, thanks again, you made my day !

I had a CURSOR to do this as a fallback in...

In addition, in the below case as well (where 100003 has the Profile ID ABCD0003), I still would like to see only ABCD001 (the profile that is common for all...

This gives me an output like the below

Customer ID

100001

100002

But I want to know which Profile ID is mapped to all the Customer IDs. Am expecting the output to be

Profile ID

ABCD001