COUNT_BIG

Returns the number of rows or values in a set of rows or values. COUNT_BIG is similar to COUNT except that the result can be greater than the maximum value of INTEGER. The argument of COUNT_BIG (*) is a set of rows. The result is the number of rows in the set. The argument of COUNT_BIG (expression) is a set of values. The result is the number of values in the set. The argument of COUNT_BIG (DISTINCT expression) is a set of values. The argument values can be any values except character strings with a length attribute greater than 2000, graphic strings with a length attribute greater than 1000 DBCS or UCS-2 characters, LOBs, or DataLinks.

Example:

Using the EMPLOYEE table, return the number of rows where the value of the SEX column is 'F'.

   SELECT COUNT(*)
      FROM EMPLOYEE
     WHERE SEX = 'F'

Returns 13 when using the sample table.