COUNT (*)
: Returns a number of rows in a table including duplicates rows and rows containing null values in any of the columns.COUNT (EXP)
: Returns the number of non-null values in the column identified by expression.COUNT (DISTINCT EXP)
: Returns the number of unique, non-null values in the column identified by expression.