Explanation:
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.
Ultimate access to all questions.
No comments yet.
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