I have tested same scenario with a non unique and unindexed column. Results are anyways same.

Yes, I have many other ways to perform the task. But point here is to test the query with or without DISTINCT.

In theory DISTINCT should not be used, but if it is giving same results then why/why not use DISTINCT!!!