count operator

count operator

Returns the number of records in the input record set.

Syntax

T | count

Parameters

NameTypeRequiredDescription
TstringThe tabular input whose records are to be counted.

Returns

This function returns a table with a single record and column of type long. The value of the only cell is the number of records in T.

Example

[!div class="nextstepaction"] Run the query

StormEvents | count

See also

For information about the count() aggregation function, see count() (aggregation function).