The correct answer is SELECT DISTINCT * FROM table_name. This statement is designed to eliminate duplicate rows from the query results by returning only distinct (different) values. The other options either misuse SQL syntax or do not achieve the intended result of removing duplicates.