COUNT

Use COUNT to count the number of records returned in a query. COUNT may also be used with COUNT DISTINCT to count the number of unique rows.

Syntax

COUNT(expression)
COUNT(DISTINCT expression)