deltaSum 

Sums the arithmetic difference between consecutive rows. If the difference is negative, it is ignored.

Syntax

deltaSum(value)

Arguments

Returned value

  • A gained arithmetic difference of the Integer or Float type.

Examples

Query:

SELECT deltaSum(arrayJoin([1, 2, 3]));

Result:

┌─deltaSum(arrayJoin([1, 2, 3]))─┐
│                              2 │
└────────────────────────────────┘

Query:

SELECT deltaSum(arrayJoin([1, 2, 3, 0, 3, 4, 2, 3]));

Result:

┌─deltaSum(arrayJoin([1, 2, 3, 0, 3, 4, 2, 3]))─┐
│                                             7 │
└───────────────────────────────────────────────┘

Query:

SELECT deltaSum(arrayJoin([2.25, 3, 4.5]));

Result:

┌─deltaSum(arrayJoin([2.25, 3, 4.5]))─┐
│                                2.25 │
└─────────────────────────────────────┘

See Also 

Rating: 4 - 1 votes

Was this content helpful?
★★★★☆