--- count(*)

The `count' aggregate function calculates the total number of
   records that satisfied the `where' or `having' clause.

Aggregate functions are only valid when used in `select' or `having'
   clauses.

EXAMPLE: 

   Compute and list the total number of employees in department 10.


	  sql> select count (*)
	  sql> from emp
	  sql> where dept_no = 10/
