Interface WindowFunctionBuilder.INthValueFinal

Namespace

LinqToDB

Assembly

linq2db.dll

Builder for NTH_VALUE. Optional FROM FIRST/LAST then optional IGNORE/RESPECT NULLS (in SQL order), then the window spec.

Chain: [.FromFirst()|.FromLast()] [.IgnoreNulls()|.RespectNulls()] [UseWindow(wnd)] | [PartitionBy(...)][.OrderBy(...)][.RowsBetween|RangeBetween...]

public interface WindowFunctionBuilder.INthValueFinal : WindowFunctionBuilder.IFromPart<WindowFunctionBuilder.INthValueNullsStep>, WindowFunctionBuilder.INullTreatmentPart<WindowFunctionBuilder.IOPartitionOOrderOFrameWithWindowFinal>, 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.IFromPart<WindowFunctionBuilder.INthValueNullsStep>.FromFirst()

WindowFunctionBuilder.IFromPart<WindowFunctionBuilder.INthValueNullsStep>.FromLast()

WindowFunctionBuilder.INullTreatmentPart<WindowFunctionBuilder.IOPartitionOOrderOFrameWithWindowFinal>.IgnoreNulls()

WindowFunctionBuilder.INullTreatmentPart<WindowFunctionBuilder.IOPartitionOOrderOFrameWithWindowFinal>.RespectNulls()

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