AnalyticQuery
A class representing an analytic query similar to the Over or Window clause in SQL.
|
AnalyticQuerySteps.AddAggregateFunctions
Step to add the first Analytic Aggregate Function.
|
AnalyticQuerySteps.AddAggregateFunctionsWithExecute
Step to add the another Analytic Aggregate Function.
|
AnalyticQuerySteps.AddNumberingFunction
Step to add the first Numbering Function.
|
AnalyticQuerySteps.AddNumberingFunctionWithExecute
Step to add the another Numbering Function.
|
AnalyticQuerySteps.AnalyticFunctions
An AnalyticFunction performs a calculation across a set of table rows that are somehow related
to the current row.
|
AnalyticQuerySteps.DefineWindowFame
First step in defining a window frame.
|
AnalyticQuerySteps.Execute |
AnalyticQuerySteps.FullAnalyticQuerySteps.FromStep |
AnalyticQuerySteps.FullAnalyticQuerySteps.OrderByOptionalStep |
AnalyticQuerySteps.FullAnalyticQuerySteps.PartitionByStep |
AnalyticQuerySteps.NameStepAggregate |
AnalyticQuerySteps.NameStepNumbering |
AnalyticQuerySteps.NumberingFunctions
Numbering functions assign integer values to each row based on their position within the
specified partition.
|
AnalyticQuerySteps.NumberingQuerySteps.FromStep |
AnalyticQuerySteps.NumberingQuerySteps.OrderByRequiredStep |
AnalyticQuerySteps.NumberingQuerySteps.PartitionByStep |
AnalyticQuerySteps.QuickQuerySteps.FromStep |
AnalyticQuerySteps.SetWindowEndOptionOne
Set the window frame boundary end.
|
AnalyticQuerySteps.SetWindowEndOptionTwo
Set the window frame boundary end.
|
AnalyticQuerySteps.SetWindowStart
Set the window frame boundary start.
|