devxlogo

The Difference between ‘Count’ and ‘Count(*)’

The Difference between ‘Count’ and ‘Count(*)’

‘Count’: Counts the number of non-null values.
‘Count(*)’: Counts the number of rows in the table, including null values and duplicates.

devx-admin

Share the Post: