Exam4Training

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

Exit mobile version