Class GroupedWindowSelect

Assembly: redb.Core.dll

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

Object→GroupedWindowSelect

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)