SQL Basics | Functions | COUNT

COUNT can retrieve how many rows of data are returned from a table.

COUNT syntax

SELECT COUNT("field_name")
FROM "table_name";

COUNT example

For example, suppose you want to find how many non-empty values exist in the store_name field of the table below.

store_information table

Enter the following command.

SELECT COUNT(store_name)
FROM store_information
WHERE store_name IS NOT NULL;

The result is as follows.

IS NOT NULL indicates that this field is not NULL, meaning it is not empty.

COUNT and DISTINCT are used together when you want to remove duplicate data from a table and count how many distinct values remain. For example, to count how many store_name values exist in the table, enter the following.

SELECT COUNT(DISTINCT store_name)
FROM store_information;

The result is as follows.