[ROOT] / doc / DocFrag / ARCQuery.QueryExpressionPivot
| Key | Value |
|---|---|
| Assembly | ARCQuery |
| DocFragType | Class |
| Name | QueryExpressionPivot |
| Namespace | ARCQuery |
| Type | QueryExpressionPivot |
ClassAttribute
| Key | Value |
|---|---|
| AssemblyName | ARCQuery |
| BaseTypes | QueryExpression |
| ClassNamespace | ARCQuery |
| ClassType | QueryExpressionPivot |
| Interfaces | ITypeDescriber; -IEquatable<QueryExpression>- |
Creates a table by querying over two keys like
For 'Order', 'PIVOT Product BY Year'.
or
'PIVOT Product BY Year SUM Amount'.
See SyntaxHelp.
See also:
QueryExpressionAggregate which aggregates over only one key
and
FunctionKeyAggregate which operates over a collection of properties.
TODO: Nov 2020: There is lot of similar code in QueryExpressionPivot and -QueryExpressionAggregate.
Generated 2025-01-13 21:59:22.681 UTC