What is the difference between count(*), count(1), count(‘a’), count(column_name)

The function of count(*), count(1), count(‘a’) is same.

That means that they all gives count of all the rows including null values.

But the function count(column_name) is different.

As when we specify a particular column in count parameter, then it gives the count of the rows excluding null values.