Question: what is the difference between count and count distinct?
Answer: What's the difference? Hi, Count would show a result of all records while count distinct will result in showing only distinct count. For instance, a table has 5 records as a,a,b,b,c then Count is 5 while Count distinct is 3.