Click or drag to resize
sqx

MEAN Structure

Aggregate [float] MEAN([float] Value)

Namespace:  sqx
Assembly:  SQX (in SQX.dll) Version: 1.0.2.6 (1.0.2.6)
Syntax
C#
Copy
[SerializableAttribute]
public struct MEAN
Remarks
Arithmetic Mean aggregate funtion.
Identical to AVG(Value) but with implicit convertion to [float].

Attributes

Format.Native, IsInvariantToDuplicates = false, IsInvariantToNulls = true, IsInvariantToOrder = true, IsNullIfEmpty = true
Examples
SQL
Copy
SELECT SUM(Value) SumValue, COUNT(*) N
, AVG(Value) [AVG], AVG(Value * sqx.OneFloat()) [AVGFloat], sqx.MEAN(Value) [MEAN]
FROM sqx.NTable(1,10)
/*
SumValue    N           AVG         AVGFloat        MEAN
----------- ----------- ----------- --------------- --------------
55          10          5           5.5             5.5*/
See Also