Scalar FunctionsOther Functionsrow_numberCopy MarkdownReturns the current row number in the serialized row set.SyntaxCopy Anchor Link Copy Textrow_number() Returns: long ExamplesCopy Anchor Link Example 1Copy Anchor Link Copy Textdatatable(weapon:string)[ "axe", "sword", "axe", "spear", "sword", "axe" ] | summarize count() by weapon | sort by weapon asc | extend r = row_number() weapon (string)count_ (long)r (long)axe31spear12sword23row_cumsumCalculates the cumulative sum of a column in a serialized row set.row_rank_denseReturns the dense rank of a column in a serialized row set: the rank starts at 1 and increments by 1 each time the column value changes, with no gaps.