Theoretically speaking select distinct is the best way but, which are the fields you want to be distinct may change in each case.

Virtually these are the problems of people who deals with , dataporting /migration not of DBAs