SQL COUNT Function

This example returns the total number of products.

SELECT COUNT(Id) AS 'Product Count'
  FROM Product

Syntax of the COUNT function.

COUNT(value)

SELECT MONTH(OrderDate) AS 'Month',
       COUNT(Id) AS 'Items Sold'
  FROM [Order]
 WHERE YEAR(OrderDate) = 2013
 GROUP BY MONTH(OrderDate)

Month	Items Sold
1	33
2	29
3	30
4	31
5	32

SELECT S.CompanyName, 
       COUNT(P.Id) AS 'Number of Products'
  FROM Product P
  JOIN Supplier S ON S.Id = P.SupplierId
 GROUP BY S.CompanyName

CompanyName	Number of Products
Aux joyeux ecclésiastiques	2
Bigfoot Breweries	3
Cooperativa de Quesos 'Las Cabras'	2
Escargots Nouveaux	1
Exotic Liquids	3

• Our Sql Aggregate Functions Reference
• Our Sql AVG Function Reference
• Our Sql SUM Function Reference