Is there any alternative in order to retrieve unique records or to avoid duplicate rows without using distinct keyword?

Answer 1

self join should do it

Answer 2

self join