MySQL

MySQL Examples and Tutorials

Difference Between COUNT(*), COUNT(1), COUNT(column name), and COUNT(DISTINCT column name)

If you have been writing SQL queries for a while, you must be aware of the COUNT() function. It’s very simple to use, but it has multiple variations which often confuses people about when and exactly how to use them. In this tutorial, we are going to learn about different variations of COUNT functions and …

Difference Between COUNT(*), COUNT(1), COUNT(column name), and COUNT(DISTINCT column name) Read More »