Window functions
COUNT OVER
Reference material for COUNT function
Count the number of values within the requested window.
For more information on usage, please refer to Window Functions
Syntax
Parameters
Parameter | Description | Supported input types |
---|---|---|
<value> | A value used for the COUNT() function. | Any numeric type |
<partition_by> | An expression used for the PARTITION BY clause. | Any |
Return Type
NUMERIC
Example
The following example generates a count of how many video game players have registered on a specific day:
Returns:
registeredon | count_of_players |
---|---|
2020-11-15 | 12 |
2020-11-16 | 8 |
2020-11-17 | 4 |
2020-11-18 | 9 |