Class GroupedWindowSelect
The window over the rows of a grouping, as the free providers write it around the grouping SQL their module
builds: SELECT g.<columns>, <func> OVER (...) AS <alias> FROM (<grouping>) g. One builder
for GroupBy and GroupByArray on every free provider; a reference that names no key and no aggregate is refused.
public static class GroupedWindowSelect
Inheritance
Methods
Build(string, IReadOnlyList<GroupFieldRequest>, IReadOnlyList<AggregateRequest>, IReadOnlyList<AggregateRequest>, IReadOnlyList<WindowFuncRequest>, IReadOnlyList<WindowFieldRequest>, IReadOnlyList<WindowOrderRequest>, Func<string, string>, bool)
public static string Build(string innerSql, IReadOnlyList<GroupFieldRequest> groupFields, IReadOnlyList<AggregateRequest> aggregations, IReadOnlyList<AggregateRequest> shownAggregates, IReadOnlyList<WindowFuncRequest> functions, IReadOnlyList<WindowFieldRequest> partitionBy, IReadOnlyList<WindowOrderRequest> orderBy, Func<string, string> quote, bool rankingNeedsOrder)
WithHiddenAggregates(IReadOnlyList<AggregateRequest>, IEnumerable<WindowFuncRequest>, IEnumerable<WindowFieldRequest>, IEnumerable<WindowOrderRequest>)
The aggregates the grouping must compute: those of the selector, then those the window partitions, orders or
public static List<AggregateRequest> WithHiddenAggregates(IReadOnlyList<AggregateRequest> shown, IEnumerable<WindowFuncRequest> functions, IEnumerable<WindowFieldRequest> partitionBy, IEnumerable<WindowOrderRequest> orderBy)