Difference between Count(*) , Count(1) ,Count(column name), Count(999999)? SQL | Oracle | Database
Difference between count(1) , count(*) and count(999999)?
Answer : nothing, they are the same, incur the same amount of work -- do the same thing, take the same amount of resources.
Difference between count(1) , count(*) and count(column name) ?
Answer : count(column name) - Skip the null values