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