|
|
|
|
|
|
|
|
|
|
version 11
COUNT ({ [ [ALL |DISTINCT] arithmetic_expression] |* } )
Description
The COUNT function returns the number of non-null values in the arithmetic_expression. The optional ALL and DISTINCT keywords are used to respectively retain or eliminate any duplicate values.
If you pass the * instead, the function returns the total number of records in the arithmetic_expression, including duplicate and NULL values.
Example
This example returns the number of movies from the MOVIES table:
SELECT COUNT(*) FROM MOVIES
See Also
|
|
|
|
|
|
|
|
|
|