Which of the following SQL statement can be used to query a table by eliminating duplicate rows from the query results?

Which of the following SQL statement can be used to query a table by eliminating duplicate rows from the query results?
A . SELECT DISTINCT * FROM table_name
B. SELECT DISTINCT * FROM table_name HAVING COUNT(*) > 1
C. SELECT DISTINCT_ROWS (*) FROM table_name
D. SELECT * FROM table_name GROUP BY * HAVING COUNT(*) < 1
E. SELECT * FROM table_name GROUP BY * HAVING COUNT(*) > 1

View Answer

Answer: A

Explanation:

The answer is SELECT DISTINCT * FROM table_name