4D v13.4

COUNT

Home

 
4D v13.4
COUNT

COUNT  


 

 

Command COUNTCOUNT ({ [ [ALL |DISTINCT] arithmetic_expression] |* } )

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

 
PROPERTIES 

Product: 4D
Theme: Functions

 
INDEX

Alphabetical list of commands

 
SEE ALSO 

AVG
SUM