Can Count(*) ever return null?

Question

Possible Duplicate:
Does COUNT(*) always return a result?

Is it possible in any scenario for the Count() function to return NULL?

Solution 1

No, it will only return a zero (or non-zero) result. SqlServer will not return null.

Solution 2

According to the MSDN page, no.

That said:

For return values greater than 2^31-1, COUNT produces an error. Use COUNT_BIG instead.

Solution 3

No.

This will be 0

select count(*)
where 0=1

This will be 1

select count(*)

Solution 4

No it returns a zero if the table does not have any records in the table

Solution 5

No. If the table or specific field being counted are empty it will return zero.

View more solutions