difference between count(*) and count(1)

Difference between count(*) and count(1) – Part 2

In the last post I have demonstrate the scenario for employee table without any index to differentiate the executions of count() and count(1). That demonstration proved that there is no any difference between count() and count(1) executions. If you have

Difference between count(*) and count(1) – Part 1

Almost everyone have used both the functions count() and count(1). I heard different views about the difference between count() and count(1) functions. Some people says that count(1) only counts the number of rows of tables first column whereas count(*) counts