Interface WindowFunctionBuilder.IOPartitionOOrderOFrameWithWindowFinal

Namespace

LinqToDB

Assembly

linq2db.dll

Builder for value window functions: FIRST_VALUE, LAST_VALUE, NTH_VALUE.

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

Supports frame specification and UseWindow (a reusable window definition from DefineWindow, an alternative to the inline clauses). Does NOT support FILTER clause.

public interface WindowFunctionBuilder.IOPartitionOOrderOFrameWithWindowFinal : WindowFunctionBuilder.IOPartitionOOrderOFrameFinal, WindowFunctionBuilder.IPartitionPart<WindowFunctionBuilder.IOrderOFrameFinal>, WindowFunctionBuilder.IOrderOFrameFinal, WindowFunctionBuilder.IOrderByPart<WindowFunctionBuilder.IOThenPartOFrameFinal>, WindowFunctionBuilder.IOFrameFinal, WindowFunctionBuilder.IFramePartFunction, WindowFunctionBuilder.IDefinedFunction, WindowFunctionBuilder.IUseWindow<WindowFunctionBuilder.IDefinedFunction>

Inherited Members

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)

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>)