Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
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
