SQLProvider

AggregateOperation Type

Namespace: FSharp.Data.Sql
Assembly: FSharp.Data.SqlProvider.Common.dll
Base Type: ValueType
All Interfaces: IEquatable<AggregateOperation> , IStructuralEquatable , IComparable<AggregateOperation> , IComparable , IStructuralComparable
Kind: Struct

Represents SQL aggregate operations for GROUP BY clauses and data summarization. Each operation includes the column name to aggregate.

Union cases

Union case	Description
`AvgOp avg` Full Usage: `AvgOp avg` Parameters: avg : `string`	Calculates the average of values in the specified column avg : `string`
`CountDistOp countDist` Full Usage: `CountDistOp countDist` Parameters: countDist : `string`	Counts the number of distinct values in the specified column countDist : `string`
`CountOp count` Full Usage: `CountOp count` Parameters: count : `string`	Counts the number of rows in the specified column count : `string`
`KeyOp key` Full Usage: `KeyOp key` Parameters: key : `string`	Groups results by the specified key column key : `string`
`MaxOp max` Full Usage: `MaxOp max` Parameters: max : `string`	Finds the maximum value in the specified column max : `string`
`MinOp min` Full Usage: `MinOp min` Parameters: min : `string`	Finds the minimum value in the specified column min : `string`
`StdDevOp std` Full Usage: `StdDevOp std` Parameters: std : `string`	Calculates the standard deviation of values in the specified column std : `string`
`SumOp sum` Full Usage: `SumOp sum` Parameters: sum : `string`	Calculates the sum of values in the specified column sum : `string`
`VarianceOp var` Full Usage: `VarianceOp var` Parameters: var : `string`	Calculates the variance of values in the specified column var : `string`

Instance members

Instance member	Description
`this.IsAvgOp` Full Usage: `this.IsAvgOp` Returns: `bool`	Returns: `bool`
`this.IsCountDistOp` Full Usage: `this.IsCountDistOp` Returns: `bool`	Returns: `bool`
`this.IsCountOp` Full Usage: `this.IsCountOp` Returns: `bool`	Returns: `bool`
`this.IsKeyOp` Full Usage: `this.IsKeyOp` Returns: `bool`	Returns: `bool`
`this.IsMaxOp` Full Usage: `this.IsMaxOp` Returns: `bool`	Returns: `bool`
`this.IsMinOp` Full Usage: `this.IsMinOp` Returns: `bool`	Returns: `bool`
`this.IsStdDevOp` Full Usage: `this.IsStdDevOp` Returns: `bool`	Returns: `bool`
`this.IsSumOp` Full Usage: `this.IsSumOp` Returns: `bool`	Returns: `bool`
`this.IsVarianceOp` Full Usage: `this.IsVarianceOp` Returns: `bool`	Returns: `bool`