Interface WindowFunctionBuilder.IAggregateFinal

Namespace

LinqToDB

Assembly

linq2db.dll

Builder for aggregate window functions with an argument: COUNT(expr), SUM, AVG, MIN, MAX.

Chain: [.Distinct()][.Filter(...)][.PartitionBy(...)][.OrderBy(...)][.RowsBetween|RangeBetween...], or .UseWindow(...).

Optional DISTINCT aggregate modifier, then the standard aggregate clauses (single-shot Distinct). UseWindow applies a reusable window definition (from DefineWindow) and is an alternative to the inline clauses, not combined with them.

public interface WindowFunctionBuilder.IAggregateFinal : WindowFunctionBuilder.IDistinctPart<WindowFunctionBuilder.IOFilterOPartitionOOrderOFrameFinal>, WindowFunctionBuilder.IOFilterOPartitionOOrderOFrameFinal, WindowFunctionBuilder.IFilterPart<WindowFunctionBuilder.IOPartitionOOrderOFrameFinal>, WindowFunctionBuilder.IOPartitionOOrderOFrameFinal, WindowFunctionBuilder.IPartitionPart<WindowFunctionBuilder.IOrderOFrameFinal>, WindowFunctionBuilder.IOrderOFrameFinal, WindowFunctionBuilder.IOrderByPart<WindowFunctionBuilder.IOThenPartOFrameFinal>, WindowFunctionBuilder.IOFrameFinal, WindowFunctionBuilder.IFramePartFunction, WindowFunctionBuilder.IDefinedFunction, WindowFunctionBuilder.IUseWindow<WindowFunctionBuilder.IDefinedFunction>, WindowFunctionBuilder.IKeepPart<WindowFunctionBuilder.IKeepOrderByRequired>

Inherited Members

WindowFunctionBuilder.IDistinctPart<WindowFunctionBuilder.IOFilterOPartitionOOrderOFrameFinal>.Distinct()

WindowFunctionBuilder.IFilterPart<WindowFunctionBuilder.IOPartitionOOrderOFrameFinal>.Filter(bool)

WindowFunctionBuilder.IPartitionPart<WindowFunctionBuilder.IOrderOFrameFinal>.PartitionBy(params object[])

WindowFunctionBuilder.IOrderByPart<WindowFunctionBuilder.IOThenPartOFrameFinal>.OrderBy(object)

WindowFunctionBuilder.IOrderByPart<WindowFunctionBuilder.IOThenPartOFrameFinal>.OrderBy(object, Sql.NullsPosition)

WindowFunctionBuilder.IOrderByPart<WindowFunctionBuilder.IOThenPartOFrameFinal>.OrderByDesc(object)

WindowFunctionBuilder.IOrderByPart<WindowFunctionBuilder.IOThenPartOFrameFinal>.OrderByDesc(object, Sql.NullsPosition)

WindowFunctionBuilder.IFramePartFunction.RowsBetween

WindowFunctionBuilder.IFramePartFunction.RangeBetween

WindowFunctionBuilder.IFramePartFunction.GroupsBetween

WindowFunctionBuilder.IFramePartFunction.RowsBetweenValues(object, object)

WindowFunctionBuilder.IFramePartFunction.RangeBetweenValues(object, object)

WindowFunctionBuilder.IFramePartFunction.GroupsBetweenValues(object, object)

WindowFunctionBuilder.IUseWindow<WindowFunctionBuilder.IDefinedFunction>.UseWindow(WindowFunctionBuilder.IDefinedWindow)

WindowFunctionBuilder.IKeepPart<WindowFunctionBuilder.IKeepOrderByRequired>.KeepFirst()

WindowFunctionBuilder.IKeepPart<WindowFunctionBuilder.IKeepOrderByRequired>.KeepLast()

Extension Methods

Sql.IsDistinctFrom<T>(T, T)

Sql.IsNotDistinctFrom<T>(T, T)

SqlExtensions.In<T>(T, T, T)

SqlExtensions.In<T>(T, T, T, T)

SqlExtensions.In<T>(T, params T[])

SqlExtensions.In<T>(T, IEnumerable<T>)

SqlExtensions.In<T>(T, IQueryable<T>)

SqlExtensions.NotIn<T>(T, T, T)

SqlExtensions.NotIn<T>(T, T, T, T)

SqlExtensions.NotIn<T>(T, params T[])

SqlExtensions.NotIn<T>(T, IEnumerable<T>)

SqlExtensions.NotIn<T>(T, IQueryable<T>)