COUNT - count records and values

Syntax

Description

    COUNT counts the number of records with no NULL-values in the specifyed field or the whole number of records in the table if '*' is used instead of specifying a column.

    Example:

SELECT COUNT(DISTINCT preis)
 FROM torder

Counts all unique values of the column preis of the table torder.