> ## Documentation Index
> Fetch the complete documentation index at: https://docs.firebolt.io/llms.txt
> Use this file to discover all available pages before exploring further.

> Reference material for COUNT function

# COUNT OVER

Count the number of values within the requested window.

For more information on usage, please refer to [Window Functions](/reference-sql/functions-reference/window)

## Syntax

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
COUNT( <value> ) OVER ( [ PARTITION BY <partition_by> ] )
```

## 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:

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
SELECT
	registeredon,
	COUNT(agecategory) OVER (PARTITION BY registeredon) AS count_of_players
FROM
	players;
```

**Returns**:

| registeredon | count\_of\_players |
| :----------- | :----------------- |
| 2020-11-15   | 12                 |
| 2020-11-16   | 8                  |
| 2020-11-17   | 4                  |
| 2020-11-18   | 9                  |