Skip to main content
COUNT

Counts the number of rows within a specified range or partition

Updated over 2 weeks ago

Description

The COUNT() function counts the number of rows within a specified range or partition. Empty values are not counted. This function is useful for summarizing data and generating row counts for reporting.

Syntax

COUNT(arg)

Output

integer

Variables

  1. arg: the field to be counted.

Example

COUNT(ID) Over (Partition by Group)

ID

Group

COUNT

1

A

3

2

A

3

3

A

3

4

0

5

B

1

Did this answer your question?