Databricks Certified Data Engineer - Associate
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
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