To solve this question, one needs to understand the difference between count(*)
and count(column_name)
.
count(*)
returns the total number of rows in the table, whereas count(column_name)
returns the number of non-null values for the given column.
Now, let's go through each option and explain why it is right or wrong:
A. True: This option is false. count(*)
will always return the same value as the number of rows in the table, while count(column_name)
will return the number of non-null values for the given column. Thus, it is possible for count(column_name)
to return a higher value than count(*)
, but not a lower value.
B. False: This option is correct. count(*)
returns the total number of rows in the table, whereas count(column_name)
returns the number of non-null values for the given column. Thus, it is not possible for count(column_name)
to return fewer rows than count(*)
.
The Answer is: B