COUNT function in MySQL

by

MySQL COUNT
In MySQL, the COUNT function is used to get the count of an expression.

Syntax:

SELECT COUNT (aggregate_expression)  
FROM table_name  
WHERE conditions;

Parameters:

Aggregate_expression: It is used to specify the column or expression to be utilized by the COUNT function.

Example: Items table:

ID NAME QUANTITY
1 Electronics 30
2 Sports 45
3 Fashion 50
4 Grocery 30
5 Toys 50

 

Query:

SELECT quantity, COUNT(*) AS “Number of Items”
FROM items
GROUP BY quantity;

Output:

QUANTITY Number of Items
30 2
45 1
50 2

Explanation:
The ‘items’ is an already existing table from which we are counting the number of Items of the same quantity value.