Interface WindowFunctionBuilder.IOPartitionROrderFinal

Namespace

LinqToDB

Assembly

linq2db.dll

Builder for ranking functions: ROW_NUMBER, RANK, DENSE_RANK, PERCENT_RANK, CUME_DIST, NTILE, LEAD, LAG.

Chain: [UseWindow(wnd)] | [PartitionBy(...)].OrderBy(...)[.ThenBy(...)]

ORDER BY is mandatory. FILTER and frame clauses are not available.

public interface WindowFunctionBuilder.IOPartitionROrderFinal : WindowFunctionBuilder.IUseWindow<WindowFunctionBuilder.IDefinedFunction>, WindowFunctionBuilder.IPartitionPart<WindowFunctionBuilder.IROrderByPartOThenByPartFinal>, WindowFunctionBuilder.IROrderByPartOThenByPartFinal, WindowFunctionBuilder.IOrderByPart<WindowFunctionBuilder.IThenByPartFinal>

Inherited Members

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

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

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

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

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

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

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