Revision as of 10:25, 1 October 2012

COUNT

COUNT finds the number of non-null values in a column.

COUNT is an aggregate function it is normally used with GROUP BY.

  SELECT region, COUNT(name)
    FROM bbc
   GROUP BY region

With a GROUP BY region statement each region shows up just once. The COUNT column gives the number of countries for each region.

SELECT region, COUNT(name)
  FROM bbc
 GROUP BY region

@@ Line 33: / Line 33: @@
    <li>[[MIN |MIN function]]</li>
 </ul>
+{{Languages}}