Ashu96

Thanks @Ingolme for the answer. Yes it's not efficient but gives the desired answer. Appreciate your explanation of the answer as well as of @niche's reply.

Hi everyone, I am currently learning SQL and was going through self join tutorial. The command for the same was as follows: The output is attached below. However there will always be duplicates in this output. How shall I remove these duplicate rows after joining them ?