Databricks Certified Data Engineer Associate · Free Practice Question Easy
Question 30
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
Reveal correct answer
Correct answer: A
Explanation
The answer is SELECT DISTINCT * FROM table_name
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
You must be logged in to post a comment.
