Click or drag to resize
sqx

FREQUENCY Structure

Aggregate [bigint] FREQUENCY([float] Value, [float] Target)

Namespace:  sqx
Assembly:  SQX (in SQX.dll) Version: 1.0.2.6 (1.0.2.6)
Syntax
C#
Copy
[SerializableAttribute]
public struct FREQUENCY
Remarks
Frequency aggregate function.

NOTE: All parameters except Value must remain constant within the GROUP BY.

Attributes

Format.Native, IsInvariantToDuplicates = false, IsInvariantToNulls = true, IsInvariantToOrder = true, IsNullIfEmpty = true
Examples
SQL
Copy
/* Example (int) */
WITH sample_data AS (SELECT ID, sqx.Geometric_PPF(Value, 0.25) X FROM sqx.UTable(10000, 0))
, sample_frequency AS (SELECT b.Value
    , sqx.FREQUENCY(s.X, b.[Value]) Frequency
    , sqx.RELFREQUENCY(s.X, b.[Value]) RelativeFrequency
    FROM (SELECT MIN(X) MinValue, MAX(X) MaxValue FROM sample_data) p
    CROSS APPLY sqx.NTable(p.MinValue, p.MaxValue) b
    CROSS JOIN sample_data s
    GROUP BY b.Value
    --HAVING sqx.FREQUENCY(s.X, b.[Value]) > 0
)
SELECT [Value], Frequency, RelativeFrequency
FROM sample_frequency
ORDER BY [Value]
SQL
Copy
/* Example (float) */
WITH sample_data AS (SELECT sqx.Exponential_PPF(Value, 0.25) X FROM sqx.UTable(10000, 0))
SELECT b.Value, sqx.FREQUENCY(ROUND(s.X, 1), b.Value) Frequency
, sqx.RELFREQUENCY(ROUND(s.X, 1), b.Value) RelativeFrequency
FROM (SELECT FLOOR(MIN(X)) MinValue, CEILING(MAX(X)) MaxValue FROM sample_data) a
CROSS APPLY sqx.XTable(a.MinValue, a.MaxValue, 0.1) b
CROSS JOIN sample_data s
GROUP BY b.Value
ORDER BY b.Value
See Also