Question: what is the difference between select count and select count 1?
Answer: Which is best to use and when? How do you specify difference between count(*) and count(1) in a select statement? Which is best to use and when? The difference is simple: COUNT(*) counts the number of rows produced by the query, whereas COUNT(1) counts the number of 1 values.