Built-In Functions and Syntax › Count

Count

The count function returns the number of occurrences of the value identified by the GROUP BY clause.

Syntax:

►►─┬─ COU ────┬─ (*) ─────────────────────────────────────────────────────────►◄
   ├─ COUNT ──┤
   ├─ NUM ────┤
   └─ NUMBER ─┘

Invocation names:

COU     NUM
COUNT   NUMBER

Example:

This example counts the number of employees in a department:

select count(*) from employee

  12