Databricks Certified Data Engineer - Associate
Get started today
Ultimate access to all questions.
Ultimate access to all questions.
What would be the result of executing the following SQL query on a table named 'customers'?
SELECT COUNT(DISTINCT *) FROM customers;
Explanation:
The COUNT(DISTINCT *) function counts all distinct rows in the 'customers' table where none of the columns have NULL values. In this scenario, if any row contains a NULL value in any column, it is excluded from the count. Therefore, the correct answer reflects the count of distinct rows excluding those with NULL values.