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.