MySQL count() Function

The MySQL count() function is used to return the count of an expression. It is used when you need to count some records of your table.

Syntax:

snippet

SELECT COUNT (aggregate_expression)
FROM table_name
[WHERE conditions];

Parameter explanation

aggregate_expression: It specifies the column or expression whose NON-NULL values will be counted.

table_name: It specifies the tables, from where you want to retrieve records. There must be at least one table listed in the FROM clause.

WHERE conditions: It is optional. It specifies the conditions that must be fulfilled for the records to be selected.

Consider a table named "officers", having the following data.

Execute the following query:

snippet

SELECT COUNT(officer_name)
FROM officers;

Output:

Here, you can see that that the COUNT function calculates the total number of officers in the table.

Related Tutorial

1 MySQL count() Function

2 MySQL sum() function

3 MySQL avg() function

4 MySQL min() function

5 MySQL max() function

6 MySQL GROUP_CONCAT() Function

7 MySQL first function

8 MySQL last function

Try it

Contents +