Berserk Docs
Tabular OperatorsAggregate Operators

count

Returns the number of rows in the input table as a single row with a single column named Count.

Syntax

count

Count all rows in the input

Examples

Example 1

datatable(warrior:string, weapon:string)[
  "Ragnar", "axe",
  "Bjorn", "sword",
  "Lagertha", "spear",
  "Ivar", "bow",
  "Floki", "hammer"
]
| count
Count (long)
5

Example 2

datatable(warrior:string, voyages:long)[
  "Ragnar", 42,
  "Bjorn", 31,
  "Lagertha", 28,
  "Ivar", 35
]
| where voyages > 30
| count
Count (long)
3

project-away

Selects all columns from the input except the specified columns.

distinct

Returns a table with the distinct combination of the provided columns of the input table.

On this page

SyntaxExamplesExample 1Example 2Related