Answer-first summary for fast verification
Answer: SELECT DISTINCT * FROM table_name
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.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Which SQL statement effectively removes duplicate rows from the query results when querying a table?
A
SELECT DISTINCT * FROM table_name HAVING COUNT(*) > 1
B
SELECT * FROM table_name GROUP BY * HAVING COUNT(*) > 1
C
SELECT DISTINCT * FROM table_name
D
SELECT * FROM table_name GROUP BY * HAVING COUNT(*) < 1
E
SELECT DISTINCT_ROWS (*) FROM table_name
No comments yet.