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

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments