Click or drag to resize
sqx

LOGADDSUM Structure

Aggregate [float] LOGADDSUM([float] LogValue)

Namespace:  sqx
Assembly:  SQX (in SQX.dll) Version: 1.0.2.6 (1.0.2.6)
Syntax
C#
Copy
[SerializableAttribute]
public struct LOGADDSUM
Remarks
LogAdd sum aggregate function.
Aggregate version of LogAdd.

Attributes

Format.Native, IsInvariantToDuplicates = false, IsInvariantToNulls = true, IsInvariantToOrder = true, IsNullIfEmpty = true
Examples
SQL
Copy
WITH sample_data AS (SELECT X FROM (VALUES (LOG(6)), (LOG(7.5)), (LOG(15))) AS T(X))
SELECT EXP(sqx.LOGADDSUM(X)) SumValue
FROM sample_data
/*
SumValue
----------------------
28.5*/
See Also