how to show all records from a specific mySQL row - except duplicates?

Question

Is there any easy way to show all records from a specific mySQL row - except the duplicated ones?

Answer 1

select distinct myrow from mytable;