Teradata tutorial for Count(*) Vs Count(1) and other count function.

Teradata: Count(*) Vs Count(1)

Lets see how below statements will behave with the example (Teradata Version 14 and above)
Note: Number in count statement(example count(1),count(2)) does not represent column order in the table, it is just plain number.

Sample Table & Data creation

Various count related Examples