COUNT

Count rows with COUNT.

COUNT returns the number of rows. COUNT(*) counts all rows, COUNT(column) counts non-NULL values.

SELECT COUNT(*) FROM products;
SELECT COUNT(price) FROM products;

This query gives total rows and non-NULL price count.

COUNT(*) is selected from products.

COUNT — details

COUNT(*) counts NULL rows too. COUNT(column) counts only non-NULL values. The difference matters.

For example, if 3 of 10 customers have no email, COUNT(*) returns 10 and COUNT(email) returns 7.

Find the total row count of products with COUNT(*).

Show example solution

SELECT COUNT(*) FROM products;

Add COUNT

SELECT ____(*) FROM products;

Show answer

SELECT COUNT(*) FROM products;

Next lesson: SUM