- All Exams Instant Download
What could be the expected output of query SELECT COUNT (DISTINCT *) FROM user on this table
What could be the expected output of query SELECT COUNT (DISTINCT *) FROM user on this table
A . 3
B. 2 (Correct)
C. 1
D. 0
E. NULL
Answer: B
Explanation:
The answer is 2,
Count (DISTINCT *) removes rows with any column with a NULL value
Latest Databricks Certified Professional Data Engineer Dumps Valid Version with 222 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund
Subscribe
Login
0 Comments
