7.22.1 COUNT(*)

(1) Specification format

set-function-COUNT(*) ::= COUNT(*)

To Page Top

(2) Rules

1. The data type of the execution result is INTEGER.

2. If the number of input rows is 0, the result will be 0.

To Page Top

(3) Example

Example

Using the data in the employee table (EMPLIST), this example determines the number of male employees in section S001.

SELECT COUNT(*) AS "COUNT"
    FROM "EMPLIST"
        WHERE "SCODE"='S001' AND "SEX"='M'

Example of execution results

To Page Top