What is the return type of COUNT(*) in SQL? As you may know, count returns the number of rows in a table. Unfortunately, neither google nor my MySQL book (Paul DuBois) appear to provide an answer. I'm ...

COUNT_BIG(*) returns the number of items in a group. This includes NULL values and duplicates. COUNT_BIG (ALL expression) evaluates expression for each row in a group, and returns the number of ...