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;
|
Difference Between Count(*) and Count(Column Name)
|