COUNT(*) returns the number of rows in each group of the result set. The return value is a BIGINT.
Syntax
COUNT ( * )
Semantics
*
indicates that the count does not apply to any specific column or expression in the select list
Notes
