deltaSum
Sums the arithmetic difference between consecutive rows. If the difference is negative, it is ignored.
Note
The underlying data must be sorted for this function to work properly. If you would like to use this function in a materialized view, you most likely want to use the deltaSumTimestamp method instead.
Syntax
deltaSum(value)
Arguments
Returned value
- A gained arithmetic difference of the
Integer
orFloat
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
当前内容版权归 ClickHouse 或其关联方所有,如需对内容或内容相关联开源项目进行关注与资助,请访问 ClickHouse .