what is the difference between select count and select count 1?
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.