COUNT

Function COUNT is also found in the following categories: Window functions.

SyntaxSyntax

COUNT(  [ value ] )

COUNT(  [ value ]
       [ FIXED ... | INCLUDE ... | EXCLUDE ... ]
       [ BEFORE FILTER BY ... ]
     )

DescriptionDescription

Returns the number of items in the group.

Can be used with constants, such as COUNT(1) or COUNT(). If the chart does not use other measures and dimensions, the result of such an expression will always be 1. This is because the function does not include any fields, so DataLens accesses no source tables in the query.

Argument types:

• value — Any

Return type: Integer

ExamplesExamples

COUNT()

COUNT([OrderID])

Data source supportData source support

ClickHouse 21.8, Microsoft SQL Server 2017 (14.0), MySQL 5.7, Oracle Database 12c (12.1), PostgreSQL 9.3, YDB.