+ 2
Why does count(*) and count(1) return different results ?
2 Respuestas
+ 2
count(1) will return only 1
whereas count(*) counts all the values satisfying
0
count ignores null values unless you use * which just counts the rows regardless of values.