Difference Between Count(*) and Count(Column Name)

Count(*) function return all the rows including duplicates where count(Column Name) does not because count(Column Name) excludes null values.

Examples:

Table: Student

select count(*) from student;

select count(name) from student;