Example
Return the number of products in the “Products” table:
SELECT COUNT(ProductID) AS NumberOfProducts FROM Products;
Definition and Usage
The COUNT() function returns the number of records returned by a select query.
Note: NULL values are not counted.
Syntax
COUNT(expression)