COUNT function counts the number of rows retrieved by a SELECT statement. The return value is of type BIGINT. The COUNT(expr) function count the number of non-NULL values of expr in the rows retrieved by a SELECT statement. SELECT COUNT(expr) FROM tbl; In contrast, COUNT(*) is different in that it returns a count of the [...]