4D v13.4COUNT |
||||||||||||||
|
4D v13.4
COUNT
COUNT
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. This example returns the number of movies from the MOVIES table: SELECT COUNT(*) |
PROPERTIES
Product: 4D INDEX SEE ALSO |
||||||||||||