Click or drag to resize
sqx

MINMAX Structure

Aggregate [Vector] MINMAX([float] Value)

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

Attributes

Format.Native, IsInvariantToDuplicates = true, IsInvariantToNulls = true, IsInvariantToOrder = true, IsNullIfEmpty = true
Examples
SQL
Copy
declare @V sqx.Vector
select @V = sqx.MINMAX(Value)
from sqx.VectorTable(sqx.RandomVector(100,1))

select *
from sqx.VectorTable(@V)
/*
ID          Value
----------- --------------------
1           0.00760086765866767  Min
2           0.997891051228107    Max*/
See Also