SQL Function Reference

COUNT

Returns the number of rows matching the condition. COUNT(*) counts all rows, COUNT(expr) counts only non-NULL values.

MySQL

COUNT([DISTINCT] expr | *)

expr | *

An expression or *, to count the number of rows or values

Examples

MySQL

SELECT COUNT(*)
FROM FamilyMembers;

MySQL

SELECT COUNT(DISTINCT STATUS)
FROM FamilyMembers;